代码
# -*- coding: utf-8 -*-
# @Author : zbz
from openpyxl import load_workbook
path = "./files/demo1.xlsx"
wb = load_workbook(filename=path)
ws = wb.active
row_num, col_num = ws.max_row, ws.max_column
items = []
for row in range(1, row_num + 1):
item = {}
for col in range(1, col_num + 1):
key = ws.cell(1, col).value
item[key] = ws.cell(row, col).value
# 第一行只是字段
if row != 1:
items.append(item)
for item in items:
print(item)