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 vote106 views1 answer
Create period pandas
Python
0 vote115 views1 answer
Djago get settings
Python
0 vote102 views1 answer
Np.linspace() in python
Python
0 vote118 views1 answer
Wxpython mainloop
Python
18 votes109 views6 answers
Gui in python
Python
2 votes106 views1 answer
How to get all index of a char of a string in python
Python
1 vote93 views1 answer
2d dictionary in python
Python
-1 vote104 views2 answers
How to find a square root of a number using python
Python
3 votes123 views1 answer
Numpy get sum
Python
0 vote128 views1 answer
Python returning rows and columns from a matrix string
Python