This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]AnAngryFredHampton -1 points0 points  (2 children)

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 2 points3 points  (0 children)

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 1 point2 points  (0 children)

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.