Guillaume Lebourgeois
Guillaume Lebourgeois

Reputation: 3873

Parsing Excel files with Python 3.x

I have found very few libraries in Python able to parse excel files, and none of them were in Python 3.x nor passed with success the 2to3 step.

What would be your suggestions ?

Upvotes: 7

Views: 7730

Answers (3)

Fred Barclay
Fred Barclay

Reputation: 834

xlsxwriter is a good tool I've found, and practically the only one for Python 3 that hasn't been discontinued. I know it works well with both Linux and Windows--LibreOffice in both Linux and Windows, and Excel in Windows.

Upvotes: 1

Scharron
Scharron

Reputation: 17817

Have a look at Python Package Index (Pypi), section Python 3 . xlrd3 is a port of xlrd, a python 2.x lib to parse Excel files.

Upvotes: 2

Lennart Regebro
Lennart Regebro

Reputation: 172437

My suggestion would be to contact the authors of the libraries and help port them. It's not horribly hard and quite fun! Your only other option is to use Python 2, and that is obviously not as fun. :)

Possibly you could export to CSV as well, but I guess you would have if that was an option.

Upvotes: 1

Related Questions