import pandas as pd
path = r'd:\1.xlsx'
df = pd.read_excel(path, header=None)
contents = []
#content_1, content_2, content_2, content_2,
for i in range(len(df[0])): #df[0]表示提取第一列
for j in range(len(df.iloc[0])): #df.iloc[0]表示提取第一行
#for j in range(81,85): #df.iloc[0]表示提取第一行
print(str(df.iloc[i,j]))
if str(df.iloc[i,j]) == 'nan':
content = '{}'.format(df.iloc[i,j])
print(content)
contents.append(content)
elif (str(type(df.iloc[i,j])) == "<class 'int'>") or (str(type(df.iloc[i,j])) == "<class 'float'>"):
content = '{}'.format(df.iloc[i,j])
print(content)
contents.append(content)
else:
content = df.iloc[i,j]