把xls,xlsx格式的文档转换成csv格式
# 使用
python xls2csv.py
# -*- coding: utf-8 -*-
import xlrd
import xlwt
import sys
from datetime import date,datetime
def read_excel(filename):
workbook = xlrd.open_workbook(filename)
# print sheet2.name,sheet2.nrows,sheet2.ncols
sheet2 = workbook.sheet_by_index(0)
for row in xrange(0, sheet2.nrows):
rows = sheet2.row_values(row)
def _tostr(cell):
if type(u'') == type(cell):
return ""%s"" % cell.encode('utf8')
else:
return ""%s"" % str(cell)
print ','.join([_tostr(cell) for cell in rows ])
if __name__ == '__main__':
filename = sys.argv[1]
read_excel(filename)
再给大家分享一则代码
xlsx文件解析处理：openpyxl库 csv文件格式生成：csv
python#coding: utf-8 # 依赖openpyxl库：http://openpyxl.readthedocs.org/en/latest/ from openpyxl import Workbook from openpyxl.compat import range from openpyxl.cell import get_column_letter from openpyxl import load_workbook import csv import os import sys def xlsx2csv(filename): try: xlsx_file_reader = load_workbook(filename=filename) for sheet in xlsx_file_reader.get_sheet_names(): # 每个sheet输出到一个csv文件中，文件名用xlsx文件名和sheet名用'_'连接 csv_filename = '{xlsx}_{sheet}.csv'.format( xlsx=os.path.splitext(filename.replace(' ', '_'))[0], sheet=sheet.replace(' ', '_')) csv_file = file(csv_filename, 'wb') csv_file_writer = csv.writer(csv_file) sheet_ranges = xlsx_file_reader[sheet] for row in sheet_ranges.rows: row_container = [] for cell in row: if type(cell.value) == unicode: row_container.append(cell.value.encode('utf-8')) else: row_container.append(str(cell.value)) csv_file_writer.writerow(row_container) csv_file.close() except Exception as e: print(e) if __name__ == '__main__': if len(sys.argv) != 2: print('usage: xlsx2csv