一、demo
from openpyxl import load_workbook
if __name__ == '__main__':
wb = load_workbook("xxx.xlsx")
sht = wb['Sheet1']
containerMap = {}
for row in sht.iter_rows(min_row=2): # 从第二行开始
i = 0
set = ""
instance = ""
for col in row:
if i == 4:
instance = col.value
if i == 7:
set = col.value
i = i + 1
if containerMap.has_key(set):
containerList = containerMap[set]
if len(containerList) <= 2:
containerList.append(instance)
else:
containerList = []
containerList.append(instance)
containerMap[set] = containerList