csv文件一键转txt文件,代码csv_to_txt.py:
import csv
filepath = input("请输入CSV文件路径:")
openfile = open(filepath, 'r', encoding='utf-8')
savepath = input("请输入保存路径和TXT文件名:")
data = csv.reader(openfile)
try:
with open(savepath, 'w', encoding='utf-8') as f:
for line in data:
for x in line:
f.write(str(x))
f.write('\t')
f.write('\n')
except Exception as error:
print("An error occurred:", error + '请确保CSV文件为UTF-8编码格式!')
openfile.close()
print("处理完成!")
利用pyinstaller封装成直接可用的.exe程序。若无pyinstaller库,需先安装该库,封装方法:
在终端(Terminal或cmd等)运行pyinstaller -F csv_to_txt.py即可,在脚本目录会自动生成xxx.spec 文件、build和 dist 目录,可执行文件csv_to_txt.exe在dist目录中。
双击执行