python-excel操作

from openpyxl import load_workbook

#1 打开Excel，返回工作簿
wb = load_workbook("test_excel01.xlsx")

#2 定位表单， 返回表单对象
sheet = wb['test']

#3 定位单元格
res = sheet.cell(1, 1).value
print(res)
print(sheet.max_row)
print(sheet.max_column)
print(sheet.cell(1, 1).value, "  " , type(sheet.cell(1, 1).value))