Which object I can use to read xlsx tempate

Question

I have an xlsx file that I use as a template.

I am tring to create a new excel file using this template how can I read this file and write it to a new xlsx file in python 27?

score 1 · Accepted Answer · answered Nov 06 '14 at 14:59

1

You may want to install the Excel module xlutils at http://www.python-excel.org/

answered Nov 06 '14 at 14:59

Megan

this package is for xls. and not for xlsx. :( – Barak Rosenfeld Nov 06 '14 at 15:11
also, this post could be useful for opening existing xlsx sheets (since xlsxwriter does not have the open option - but you can save): http://stackoverflow.com/questions/18002133/xlsxwriter-is-there-a-way-to-open-an-existing-worksheet-in-my-workbook – Megan Nov 06 '14 at 15:33

score 0 · Answer 2 · answered Nov 07 '14 at 19:12

0

You can use openpyxl to edit existing xlsx files or save them as new files.

answered Nov 07 '14 at 19:12

Charlie Clark

2 Answers2