csv2xls sample

readme.md

chmod +x csv2xls.py ./csv2xls.py

python csv2xls.py

可以处理编码为GBK和UTF-8的CSV文件

csv2xls.py

#!/usr/bin/python
# -*- coding: utf-8 -*-
 
import csv
import xlwt
import os
import sys
 
def cvstran2xls(filename):
	with open(filename,'rb') as f:
		reader = csv.reader(f)
		cvscontent = []
		for row in reader:
			try:
			  cvscontent.append([x.decode('utf-8') for x in row])
			except:
			  cvscontent.append([x.decode('gbk') for x in row])
 
	file = xlwt.Workbook()
	table = file.add_sheet('sheet1',cell_overwrite_ok = True)
 
 
	for row in range(len(cvscontent)):
		for col in range(len(cvscontent[row])):
			table.write(row,col,cvscontent[row][col])
 
	file.save(os.path.splitext(filename)[0]+'.xls')
	print os.path.splitext(filename)[0]+'.xls','OK'
 
 
# if __name__ == '__main__':
# 	print sys.argv[1],'Ready'
# 	cvstran2xls(sys.argv[1])
 
cvstran2xls('test.csv')