Question on python xlrd

Question

How to know the total number of columns used in an excel sheet in the following link http://scienceoss.com/read-excel-files-from-python/

Thanks..

Answer 1

The Sheet class has a ncols member which indicates the number of columns

Answer 2

Here are the first 6 lines in the "Quick Start" section of xlrd's README.html:

import xlrd
book = xlrd.open_workbook("myfile.xls")
print "The number of worksheets is", book.nsheets
print "Worksheet name(s):", book.sheet_names()
sh = book.sheet_by_index(0)
print sh.name, sh.nrows, sh.ncols

You can get a tutorial via this link. Likewise the latest SVN commit of the docs. If you installed xlrd from a source distribution or by running a Windows installer, you should already have the docs.