CEC6ComprehensiveManagement/docs/read_excel.py

import openpyxl

# 打开工作簿
workbook = openpyxl.load_workbook('./资源模型及评估模型数据库定义表20230816.xlsx')
# 选择工作表
sheet = workbook['资源模型数据库数据定义']

# 遍历行
for row in sheet.iter_rows(min_row=2, values_only=True):
    col_classify = row[1]
    col_name = row[4]
    col_key = row[5]

    if col_classify is not None:
        print(f'// {col_classify}')
    if col_name is not None and col_key is not None:
        print(f'{col_key}("{col_key}", "{col_name}"),')

    # if col_name is None or col_key is None:
    #     print(f'------ col_name: {col_name},col_key: {col_key}')
workbook.close()