python链接excel

1、打开excel并读取

import xlrd
print(type(xlrd))

file = 'D:\\test.xlsx'
wb = xlrd.open_workbook(filename=file)     #表格对象#
ws = wb.sheet_by_name('Sheet2')           #sheet对象#
print(ws.nrows)                 #行数
print(ws.ncols)                 #列数
dateset=[]                    #空数组#
for r in range(ws.nrows):    #循环读取行数#
    col=[]                   #数组#
    for c in range(ws.ncols):        #读列#
        col.append(ws.cell(r,c).value)  #读取单元格数据，读取一行#
    dateset.append(col)     #修改结尾，增加col，补充一行#
from pprint import pprint
pprint(dateset)