How Python uses xlrd to read Excel format files

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

Using XLRD can easily read the contents of the 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 xlrdfname = "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 nonenrows = Sh.nrowsncols = Sh.ncolsprint "nr oWS%d, ncols%d "% (nrows,ncols) Cell_value = Sh.cell_value (all) print cell_valuerow_list = []for i in Range (1,nrows):  Row_data = Sh.row_values (i)  row_list.append (Row_data)

Hopefully this article will help you with Python programming.

