python 从xls文件中读入数据

导入模块  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)