下载xlrd模块,将下载完解压后的 xlrd-0.9.4 文件夹copy到Python目录下的lib中,然后eclipse里Windows——preferences——PyDev——Interpreters——Python Interpreter——libraries——New Folder 将xlrd-0.9.4引入即可import xlrd。【经过验证的代码】
import xlrd
fname = "test.xlsx"
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,0)
print cell_value
#print cell_value
row_list = []
row_list_1 = []
#获取各行数据
for i in range(0,nrows):
row_data = sh.row_values(i) #获取一行数据,用sh.cell_value()可只获取一个数据。
print row_data
row_list.extend(row_data)
printrow_list