Openpyxl -在字典中添加来自两个不同Excel行的键、值对

from openpyxl import load_workbook

# 加载Excel文件
workbook = load_workbook('example.xlsx')

# 选择工作表
sheet = workbook['Sheet1']

# 获取行数和列数
rows = sheet.max_row
cols = sheet.max_column

# 创建一个空字典
data_dict = {}

# 遍历Excel行
for row in range(2, rows+1):
    # 获取第一列和第二列的值
    key = sheet.cell(row=row, column=1).value
    value = sheet.cell(row=row, column=2).value
    
    # 将键值对添加到字典中
    data_dict[key] = value

# 打印字典
print(data_dict)