Xlrd documentation

import xlrd
book = xlrd.open_workbook("myfile.xls")
print("The number of worksheets is {0}".format(book.nsheets))
print("Worksheet name(s): {0}".format(book.sheet_names()))
sh = book.sheet_by_index(0)
print("{0} {1} {2}".format(sh.name, sh.nrows, sh.ncols))
print("Cell D30 is {0}".format(sh.cell_value(rowx=29, colx=3)))
for rx in range(sh.nrows):
    print(sh.row(rx))

Source: xlrd.readthedocs.io

Similar codes

0 vote132 views1 answer
Int' object is not subscriptable in python
Python
-1 vote84 views1 answer
Get key from dict python
Python
0 vote136 views1 answer
Unicode error python
Python
0 vote120 views1 answer
Spark.read.load
Python
0 vote130 views1 answer
'jet' is not a registered namespace
Python
3 votes153 views2 answers
List of dictionary values
Python
0 vote174 views1 answer
Django filter word count greater than
Python Django
4 votes148 views1 answer
Change selected option optionmenu tkinter
Python
0 vote156 views1 answer
Encanto meaning spanish
Python
111 votes121 views6 answers
Do while in python
Python