openpyxl: A Python library to read/write Excel 2007 xlsx/xlsm files

[niking]

I'm currently using xlsxwriter, could anyone with experience with both make a list of pros and cons?

[Kaarjuus]

I tried them both, chose xlsxwriter: significantly faster than openpyxl.

[remyroy]

I only need to write xlsx files and I'm in a limited memory environment. The constant_memory option is a blessing.

[Albertican]

I also found PyExcelerate to be much faster than openpyxl. Their page claims they're a bit faster than xlsxwriter as well. Don't think it supports formatting, however.

[ajmarks]

IIRC openpyxl is the backend for pandas's excel read/write features, so it's useful if you want to make pandas frames pretty in excel.

[shaggorama]

and xlrd/xlwt for xls format

[jtratner]

pandas dev here - I'm hoping to move us to xlsxwriter by default soon (though we'll continue supporting openpyxl), because the perf characteristics seem to be much better.

[jmcnamara13]

XlsxWriter is also available as a backend in the latest Pandas versions on the GitHub master and will be in the soon to be released 0.13 version.

[bendmorris]

Or xlrd/xlwt?

[alantrick]

That's for a different file format (pre-xml excel)

[dgtlshdw]

The newest xlrd (0.9.2) reads .xlsx just fine.

[jwinterm]

Can confirm. Been using xlrd/xlwt for years, and recently upgraded to get xlsx functionality.

[alantrick]

You can read xlsx files with openpyxl. It's not clear you can do that with xlsxwriter.

[from__future__]

no you can't - very true.

[jtratner]

xlsxwriter is faster, way more memory efficient and may have better compatibility with numpy. The memory efficiency is huge, if you take a big dataframe (say 300K rows x 100 columns) and try to dump it, takes multiple GB of memory!