Python Loop to Create Sheets Using Openpyxl

Question

I am trying to create a loop to add sheets to an excel file based on names in a list. For some reason it is not working. Would appreciate some help.

import openpyxl

worksheets = ['Balance Sheet Entries',
              'Production Costs',
              'Model - Realised',
              'Orders',
              'Manufacturing Comparison',
              'Unit Economics']

# File where new sheets should be created
template = openpyxl.load_workbook('New File.xlsx')

#Loop through worksheets and create one new sheet using each name in the list.
for i in range(len(worksheets)):
    template.create_sheet(worksheets[i]) #or template.create_sheet(title=worksheets[i])

The outcome of running this is exactly nothing. Nothing happens to the file and the code runs fine "Process finished with exit code 0".

Any help appreciated.

The pythonic way to loop through a list is for worksheet in worksheets. — SuperStormer
– SuperStormer, Commented Sep 1, 2020 at 21:32
@SuperStormer yes, thanks for that. I'm still a beginner on this. — OdaTruth
– OdaTruth, Commented Sep 2, 2020 at 8:42

SuperStormer · Accepted Answer · 2020-09-01 21:35:33Z

2

A quick scan through the docs suggests you need to call template.save(filename) in order to actually save to disk.

answered Sep 1, 2020 at 21:35

SuperStormer

5,5185 gold badges29 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python Loop to Create Sheets Using Openpyxl

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related