打开并读取Excel中的数据
import pandas as pd
df = pd.read_excel("/MyPath/fileName.xlsx")
for index, row in df.iterrows():
print(row)
print(row[0])
print(row['colName']
import pandas as pd
df = pd.read_excel("/MyPath/fileName.xlsx")
for index, row in df.iterrows():
print(row)
print(row[0])
print(row['colName']