å®è£
xlrd
import xlrd
fname = "reflect.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
#è·åè¡æ°
nrows = 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)
以ä¸ä¾åè·åExcelæ个Sheetçåå
æ ¼å
容ï¼
è·å¾å
容ä¹åï¼è¿è¡å¤çå°±è¡äº
æä¸ç¥éä½ åçç½ç«ãgetâ¦â¦æ³è¦æä¹å¤çï¼ä½ åºè¯¥ä¼ç