Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Reading .xlsx format in python

I've got to read .xlsx file every 10min in python.
What is the most efficient way to do this?
I've tried using xlrd, but it doesn't read .xlsx - according to documentation he does, but I can't do this - getting Unsupported format, or corrupt file exceptions.
What is the best way to read xlsx?
I need to read comments in cells too.

like image 283
Djent Avatar asked Jul 21 '11 08:07

Djent


1 Answers

xlrd hasn't released the version yet to read xlsx. Until then, Eric Gazoni built a package called openpyxl - reads xlsx files, and does limited writing of them.

like image 166
Adam Morris Avatar answered Sep 17 '22 09:09

Adam Morris