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: