.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(lines+'.xlsx','Sheet1',index_col=0)
data.to_csv('data.csv',encoding='utf-8')