Python

Search

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))

Comment

PREVIOUS	NEXT

Code Example
Python :: how to register a model in django
Python :: created by and updated by in django
Python :: Python re.subn()
Python :: how to write a function in python
Python :: how to unimport a file python
Python :: dataframe, groupby, select one
Python :: How to shift non nan values up and put nan values down
Python :: python autoclick website
Python :: delete content of table django
Python :: not using first row as index pandas
Python :: random list generator
Python :: post from postman and receive in python
Python :: label binarizer
Python :: Python operator to use for set union
Python :: topological sort
Python :: assign exec function to variable python
Python :: How to Add a overall Title to Seaborn Plots
Python :: generate python
Python :: python responses
Python :: how to perform in_order traversal of a binary tree
Python :: lambda expression python
Python :: python escape forward slash
Python :: how to split a string by colon in python
Python :: determinant of 3x3 numpy
Python :: Removing Elements from Python Dictionary Using popitem() method
Python :: remove timezone from a datetime object?
Python :: django edit object foreign key id
Python :: streamlit cheatsheet
Python :: how to print second largest number in python
Python :: python remove

Search

PYTHON

xlrd documentation

ADD CONTENT