python openpyxl读取excel

一、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