python 批量CSV转EXCEL源码

import os import glob import csv from xlsxwriter.workbook import Workbook import chardet from os import listdir from chardet import detect import sys import codecs import chardet L=[] N=[] file_dir="1" file_dir2="" a="1" file_dir=os.getcwd() print("开始执行"+file_dir+"目录下csv数据采集和excel清理，按任意键确认..") input() for root, dirs, files in os.walk(file_dir): for file in files: if os.path.splitext(file)[1] == '.csv': # 想要保存的文件格式 L.append(os.path.join(root, file)) elif os.path.splitext(file)[1] == '.xlsx': os.remove(os.path.join(root, file)) print("删除"+os.path.join(root, file)+"成功！") print("开始执行转换...") for csvfile in L: M=csvfile.rsplit("\\",1) N=M[1].split(".") workbook = Workbook(M[0]+"/"+N[0]+".xlsx") worksheet = workbook.add_worksheet() with open(csvfile, 'rt', encoding="UTF-8") as f: reader = csv.reader(f) l = 0 i=0 cr=0 firstrow=None for r, row in enumerate(reader): if r==0: firstrow=row if l%500000==0 and l>0: cr=1 workbook.close() i=i+1 workbook = Workbook(M[0]+"/"+N[0]+"_"+str(i)+".xlsx") worksheet = workbook.add_worksheet() #for c, col in enumerate(firstrow): #worksheet.write(0, c, col) for c, col in enumerate(row): worksheet.write(cr, c, col) l=l+1 cr=cr+1 workbook.close() print(N[0]+" 转换成功！") print("转换完毕！") input()