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 vote186 views2 answers
Dd-mm-yy to yyyy-mm-dd in python
Python
2 votes178 views2 answers
Count gabarit django
Python
1 vote261 views1 answer
Python get list of all open windows
Python
1 vote175 views1 answer
Cool advances python ptoject ideas
Python
0 vote200 views1 answer
Cv2 gaussian blur
Python
5 votes197 views2 answers
Set type of column pandas
Python
3 votes195 views1 answer
How to connect templates in django
Python
0 vote194 views1 answer
Python generalised eigenvalue problem
Python
0 vote203 views3 answers
Seaborn heatmap x labels horizontal
Python
0 vote187 views1 answer
Numpy collapse last dimension
Python