python 动态导入示例

from openpyxl import load_workbook

def get_title():
    return {"facets": [{"facet_id": "1", "facet_name": "主流交付场景",
                        "cards": [{"card_id": "1", "card_name": "卡片1"},
                                  {"card_id": "2", "card_name": "卡片2"}]
                        },
                       {"facet_id": "2", "facet_name": "基本能力",
                        "cards": [{"card_id": "3", "card_name": "卡片3"},
                                  {"card_id": "4", "card_name": "卡片4"}
                                  ]}]}


def test_import():
    index_map = {}
    index_map[2] = "staff_id"
    index_map[3] = "staff_name"

    index_map_start = 4
    title = get_title()
    for index1, facet_item in enumerate(title['facets']):
        for index2, card_item in enumerate(facet_item["cards"]):
            index_map[index_map_start] = f'facet{facet_item["facet_id"]}_card{card_item["card_id"]}'
            index_map_start += 1

    # 读取已存在的excel工作薄
    wb = load_workbook('test.xlsx')
    sheet = wb.active

    # 导入的结果数据
    result = []
    # 从第3行开始读
    for row_index in range(3, sheet.max_row):
        # 读完的行数据存放
        row_data = {}
        # 从第2列开始读
        for col_index in range(2, index_map_start):
            filed_name = index_map[col_index]
            row_data[index_map[col_index]] = sheet.cell(row_index, col_index).value
        result.append(row_data)

    return result


if __name__ == '__main__':
    result = test_import()
    print(result)