I need to add a value to every 3rd column in the second row starting at the 16th column going to the max column. The code I have puts a value in every cell on the second row but starts it at the 18th column. How do I iterate through skipping a certain number of columns each time?
for col in range(16, ws.max_column+1): col = col+2 ws_date = ws.cell(2, column=col) ws_date.value = 2023
Should look like: