Menu
Can xlsxwriter object use a template of another excel file?
I tried to use xlsr but it can't use a template.
I am using xlsxwriter since I am writing more the 65335 lines.
Thanks.
669
This only works for a workbook/worksheet created with XlsxWriter. XlsxWriter cannot read an existing file.
XlsxWriter vs openpyxl: What are the differences? Developers describe XlsxWriter as "A Python module for creating Excel XLSX files". A Python module for creating Excel XLSX files. On the other hand, openpyxl is detailed as "A Python library to read/write Excel 2010 xlsx/xlsm files".
From the XlsxWriter FAQ:
Q. Can XlsxWriter use an existing Excel file as a template?
No.
XlsxWriter is designed only as a file writer. It cannot read or modify an existing Excel file.
OpenPyXL can read and rewrite files and handle the Excel 2007 format.
59
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
