Python: Writing To Excel 2007+ Files (.xlsx Files)

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.

Solution 1:

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

Solution 2:

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

Solution 3:

You should take a look at xlsxcessive. It's for writing xlsx files, and is, perhaps, a bit more pythonic.

Solution 4:

The XlsxWriter Python module writes 2007+ xlsx files.

Solution 5:

If you are on Windows and have Excel 2007+ installed, you should be able to use pywin32 and COM to write XLSX files using almost the same code as you would would to write XLS files ... just change the "save as ...." part at the end.

Probably, you can also write XLSX files using Excel 2003 with the freely downloadable add-on kit but the number of rows per sheet would be limited to 64K.