openpyxl解决方案入门

import openpyxl

wb = openpyxl.load_workbook('bill.xlsx')

print(type(wb))    # <class 'openpyxl.workbook.workbook.Workbook'>

sheet_names = wb.get_sheet.names()   # ['Sheet1', 'Sheet2', 'sheet3', '空表']

sheet = wb.get_sheet_by_name('空表')    # <Worksheet "空表">

print(wb.active)    # <Worksheet "空表">

e = sheet['A1']

print(e.value,e.row,e.column)    # '外晒图纸明细统计表' 1 1

f = sheet.cell(row=2,column=4)

print(f.value)