环境信息:python3
import pandas as pd
def create_system_alert_sql():
# 读取第四列内容,且不带列名
df = pd.read_excel("/Users/rudy/Desktop/exceltool/temp.xlsx", usecols=[4],
names=None) # 读取项目名称列,不要列名
df_li = df.values.tolist()
for s_li in df_li:
print(s_li[0])
if __name__ == '__main__':
create_network_alert_sql()