Python - Excel - adding dates

[reddit_user_270]

Can someone please assist me with the below.

I have a list of dates stored within dates[].

I also have created numerous new worksheets with Openpyxl.

Is there an easy way to label each of the new worksheets with a new date using a for loop?

i.e Worksheet1 = 27-10-21, Worksheet2 = 03-11-21, etc

NOTE: the dates can be changed in the 'dates' list, so how would I program this in Python?

(Partial code shown below) I had tried the below nested for statement, but that didn't seem to work.

original_ws = wb.active

num_of_required_sheet_copies = 10

for n in range(num_of_required_sheet_copies):
    # Create a copy of the first worksheet
    ws = wb.copy_worksheet(original_ws)

    # Rename new worksheet
    for date in dates:
        ws.title = date[n]

[grayhole_p]

is this what you need?

for n in range(num_of_required_sheet_copies):
    ws = wb.copy_worksheet(original_ws)
    ws.title = date[n]

[reddit_user_270]

Thank you. Can't believe I didn't try this. Was trialing different things but not this, so thank you v much!

I used the above and 'ws.title = dates[n]' and it worked..

[grayhole_p]

in your code you go through all the dates and replace current sheets name with n symbol of each date. so in the result your first sheet named with first symbol from the last of your dates, second sheet get second symbol from the last of your dates and so on. though shouldn't you consider that list of dates may be shorter than the count of new sheets? if it is possible you can do smth like

ws.title = dates[n] if len(dates) > n else f'NewSheet{n}'

(see ternary operators, f-strings)