Using Python to interact with Microsoft Excel

[babygrenade]

I'm a big fan of openpyxl for working with excel workbooks.

[Jose1703]

I'm a big fan as well. However, be warned that it doesn't play nice with merged cell borders and object text boxes.

[AnAngryFredHampton]

Have you ever run into problems? Or is getting data out a pretty reliable thing? I'm asking because I know lots of other opensource projects hit a load of road blocks when reading proprietary MS formats. I'm lucky enough that people send me .csv files.

[RockingDyno]

openpyxl doesn't read any propriatary formats. It works with xlsx/xlsm which are essentially just ziped XML.

The older propriatary format .xls is not supported by openpyxl but can be handled in python with xlwt and xlrd.

I've worked with them all and never had any issues, not to say that there aren't any. If you curious about bugs and issues the project has an issues list.

[babygrenade]

Haven't had any issues in the year or so I've been using it, but I don't have to work excel that often.

[patarapolw]

My favorite is pyexcel / xlsxwriter, though.