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

df = pd.read_excel(r"C:\Users\Administrator\Desktop\点检表配置.xls", sheet_name="昌西一风电场-甘肃-大唐")

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