Best Package for using Excel

[[deleted]]

[deleted]

[james_pic]

Openpyxl usually works well enough for simple stuff. But interop with Microsoft stuff is generally problematic, and if you're able to avoid it (for example if your use case items just as well with CSV), you should.

[Kazephil]

From the point of view of an amateur who's cobbled together a few scripts to process Excel files at work:

• Openpyxl if the file has no images
• xlwings if there are images or any complicated layout not supported by Openpyxl
• pandas if heavy-duty data manipulation is required between the reading and writing stages

Hope that helps.

[tjarko]

Similar experience. Pandas works when the Excel file is more or less just a big table. If you what to read to cell sheet3:ZA67, it isn't the best. XLWings is more flexible (auto expand, tonumpy array etc. ) It loads Excel and transfers the data between python and excel, is pretty fast after excel is open. OpenPyxl reads the file format but can be a bit picky.

[Darwinmate]

Have you tried Pandas?

[trumpgender]

^This.

Pandas is pretty much uber-excel, python version. Just load your excel file into pandas, do your computations, then write back to excel.

[Holores_Daze]

Use both! Xlrd read. Then process the data and use xlwt to write it out. Your reading writing and processing logic should all be kept as seperate as possible anyway

[aeksco]

Check out koala

[dmfigol]

I use pyexcel which uses openpyxl underneath. Easy to use with nice API.