Parsing Excel files with Python 3.x

Question

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 ?

Scharron · Accepted Answer · 2011-02-23 12:14:41Z

2

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.

answered Feb 23, 2011 at 12:14

Scharron

17.8k6 gold badges45 silver badges63 bronze badges

Add a comment |

Lennart Regebro · Accepted Answer · 2011-02-20 14:53:01Z

1

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.

answered Feb 20, 2011 at 14:53

Lennart Regebro

173k45 gold badges229 silver badges253 bronze badges

1

I've begun some work to port the library, but it seems to be quite complicated. Concerning the CSV option, as you guessed I can't ;)
– Guillaume Lebourgeois
Commented Feb 20, 2011 at 15:00

Add a comment |

Fred Barclay · Accepted Answer · 2015-06-24 00:39:40Z

1

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.

edited Jun 24, 2015 at 0:39

answered Jun 24, 2015 at 0:19

Fred Barclay

8341 gold badge13 silver badges24 bronze badges

Add a comment |

Collectives™ on Stack Overflow

Parsing Excel files with Python 3.x

3 Answers 3

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Related