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

1 vote114 views1 answer
Python remove none from dict
Python
2 votes116 views1 answer
Logout in discord.py
Python
1 vote116 views2 answers
How to print 0 to 10 in python
Python
0 vote103 views1 answer
Shape
Python
109 votes111 views6 answers
While loop in python
Python
1 vote117 views1 answer
Subprocess print logs
Python
0 vote109 views1 answer
How to save a python object in a file
Python
0 vote141 views1 answer
Median absolute deviation scipy
Python
1 vote108 views1 answer
Python loop every month datetime
Python
0 vote116 views1 answer
Can i register a list in python for input
Python