import openpyxl
workspace=openpyxl.load_workbook('填表的数据.xlsx')
sheet=workspace.active
result={}
for col in range(1,41):
if sheet['H'][col].value not in result:
result[sheet['H'][col].value]=[]
if sheet['E'][col].value not in result[sheet['H'][col].value]:
result[sheet['H'][col].value].append(sheet['E'][col].value)
print(result)