How Python uses xlrd to read Excel format files _python

This example describes how Python uses xlrd to read Excel format files. Share to everyone for your reference. Specifically as follows:

Using XLRD can easily read the contents of Excel file, and this is a cross-platform library, can be used in Windows,linux/unix, and other platforms, the code is as follows:

Import xlrd
fname = "Sample.xls"
bk = Xlrd.open_workbook (fname)
Shxrange = Range (bk.nsheets)
try:
  sh = bk.sheet_by_name ("Sheet1")
except:
  print ' No sheet in%s named Sheet1 '% fname return
  None
nrow s = sh.nrows
ncols = sh.ncols
print "nrows%d, ncols%d"% (nrows,ncols)
cell_value = Sh.cell_value (1,1) 
  print cell_value
row_list = [] for
I in range (1,nrows):
  row_data = sh.row_values (i)
  Row_ List.append (Row_data)

I hope this article will help you with your Python programming.