导入模块 xlrd (xlwt向excel中写入信息模块)
import xlrd
wb = xlrd.open_workbook(filename="***.xls")
ws = wb.sheel_by_name("Sheet2")
dataset = []
for r in range(ws.nrows):
col = []
index = 0
for c in range(ws.ncols):
col.append(ws.cell(r,c).value)
index += 1
dataset.append(col)
pprint(dataset)