p1.xlsx
数据导出页:
用户列表页:
sheet1:
sheet2:
from openpyxl import load_workbook
wb = load_workbook("files/p1.xlsx")
# 获取所有sheet名称
print(wb.sheetnames)
# 读取第一行第一列
sheet = wb["数据导出"]
cell = sheet.cell(1,1)
print(cell.value)
# 基于索引位置获取第一行第二列
sheet = wb.worksheets[0]
cell = sheet.cell(1,2)
print(cell.value)
# 获取每个sheet的第一行第一列
for name in wb.sheetnames:
sheet = wb[name]
cell = sheet.cell(1,1)
print(cell.value)
# 获取每个sheet第一行第一列基于索引位置
for sheet in wb.worksheets:
cell = sheet.cell(1,1)
print(cell.value)