Menu
Is there a Python module that writes Excel 2007+ files?
I'm interested in writing a file longer than 65535 lines and only Excel 2007+ supports it.
202
To open XLSX files in Excel, simply double click on the file. If you have a compatible version of Excel installed on your computer (i.e. 2007 or higher), the file will automatically open.
Write Excel File Using openpyxl Module xlsx, xlsm, xltx, and xltm files. You can check it by running type(wb). The load_workbook() function takes an argument and returns a workbook object, which represents the file. Make sure that you are in the same directory where your spreadsheet is located.
Take a look at Eric' Gazoni's openpyxl project. The code can be found on bitbucket.
179
There are two libraries you can take a look at.
Python-xlsx and PyXLSX
EDIT: As the comments mention, for writing you check out openpyxl
10
You should take a look at xlsxcessive. It's for writing xlsx files, and is, perhaps, a bit more pythonic.
8
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
