待处理excel内容:
导入pandas包,读取excel指定列
import pandas as pd
# 两个文件路径
io = r'C:\PyCharm\test.xlsx'
# 读取读取第五行
data = pd.read_excel(io, usecols=[4], names=None)
result = []
data = data.values.tolist()
for s_li in data:
print(s_li)
result.append(s_li)
输出: