.py目录下有
1.xlsx，2.xlsx，3.xlsx
有一个1.txt，内容是
1
2
3
python读取1.txt根据内容转换对应xlsx为csv
我现在txt读取出来了，存入数组，再读取数组转换xlsx只能转换最后一个xlsx，打印的时候是1,2,3，数组只有最后一个，不明白为什么
import numpy as np
import pandas as pd
i=0
with open('123.txt','r') as f:
for line in f.readlines():
line = line.strip().split()
i+=1
b =line[0:1]
lines = np.array(b)
print(lines)
for i in range(0,len(lines)):
print(lines[i])
data = pd.read_excel('1.xlsx','Sheet1',index_col=0)
data.to_csv('data.csv',encoding='utf-8')
