generate_trans_cols.py 581 B

1234567891011121314151617
  1. # -*- coding: utf-8 -*-
  2. # @Time : 2024/5/31
  3. # @Author : 魏志亮
  4. import numpy as np
  5. import pandas as pd
  6. df = pd.read_excel(r"C:\Users\Administrator\Downloads\点检表配置.xls", sheet_name="和风元宝山-河南-大唐")
  7. df.replace(np.nan, '', inplace=True)
  8. # print("trans_col:")
  9. for cn, en, sec, min in zip(df['中文名'], df['英文名'], df['秒级映射'], df['分钟级映射']):
  10. # print(f"\t#{cn}\n\t{en}: {min}")
  11. print(f'{en} = gr.Textbox(label="{cn}({en})")')
  12. for i in range(2,11):
  13. print(f'param{i} = gr.Textbox(label="预留字段{i}(param{i})")')