Python: Writing to Excel 2007+ files (.xlsx files)

python excel excel-2007 openpyxl
Jonathan picture Jonathan · Nov 23, 2010 · Viewed 21.2k times · Source

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.

Answer

Mark Baker picture Mark Baker · Nov 23, 2010

Take a look at Eric' Gazoni's openpyxl project. The code can be found on bitbucket.

Related questions

Python and Excel: Overwriting an existing file always prompts, despite XlSaveConflictResolution value

I'm using the Excel.Application COM object from a Python program to open a CSV file and save it as an Excel workbook. If the target file already exists, then I am prompted with this message: "A file named '...…

Read More
Writing to an Excel spreadsheet

I am new to Python. I need to write some data from my program to a spreadsheet. I've searched online and there seem to be many packages available (xlwt, XlsXcessive, openpyxl). Others suggest to write to a .csv file (never …

Read More
IndexError: too many indices for array

I know there is a ton of these threads but all of them are for very simple cases like 3x3 matrices and things of that sort and the solutions do not even begin to apply to my situation. So I'm …

Read More