# xls_csv
把xls,xlsx格式的文档转换成csv格式
# 使用
python xls2csv.py <xls or xlsx file path>
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
# -*- 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
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
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 <xlsx file name>')
else:
xlsx2csv(sys.argv[1])
sys.exit(0)
|