Reading .xlsx format in python

Question

I need to read a .xlsx file every 10 minutes in python.
What is the most efficient way to do this?
I tried using xlrd but it does not read .xlsx - according to the documentation it does, but I cannot do it - getting Unsupported format, or corrupt file .
What is the best way to read xlsx?
I also need to read comments in cells.

Answer 1

xlrd has not yet released the xlsx reader version. Until then, Eric Ghazoni has built a package called openpyxl - it reads xlsx files and limits their writing.