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 vote134 views1 answer
Sequence with numbers in python
Python
1 vote149 views1 answer
How tyo make a constantly adding variable in python
Python
5 votes154 views4 answers
Python open mat file
Python
6 votes142 views1 answer
Python check if number
Python
4 votes153 views2 answers
Python strptime format codes
Python
1 vote180 views1 answer
Pandas dataframe remove rows by column value
Python
3 votes158 views2 answers
Django change user password
Python
0 vote140 views1 answer
Pandas filter length of string
Python
0 vote195 views2 answers
Scikit learn decistion tree
Python
1 vote153 views1 answer
X= [10] def List_ex(): x.append(20) def add_list(): x=[30,40] x.append(50) print (x) List_ex() print (x) add_list() print (x)
Python