Recommend a python library to read Excel xls files

Question

Anyone doing this currently? What do you use?

Answer 1

xlrd

Answer 2

xlrd is "a library for developers to use to extract information from Microsoft Excel spreadsheet files."

import xlrd

book = xlrd.open_workbook('myfile.xls')

print book.nsheets
print book.sheet_names()

sh = book.sheet_by_index(0)
print sh.name, sh.nrows, sh.ncols