# -*- coding: utf-8 -*-
# @Time    : 2024/5/31
# @Author  : 魏志亮
import numpy as np
import pandas as pd

df = pd.read_excel(r"C:\Users\Administrator\Downloads\点检表配置.xls", sheet_name="和风元宝山-河南-大唐")

df.replace(np.nan, '', inplace=True)
# print("trans_col:")
for cn, en, sec, min in zip(df['中文名'], df['英文名'], df['秒级映射'], df['分钟级映射']):
    # print(f"\t#{cn}\n\t{en}: {min}")
    print(f'{en} = gr.Textbox(label="{cn}({en})")')


for i in range(2,11):
    print(f'param{i} = gr.Textbox(label="预留字段{i}(param{i})")')