# 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 xlrdimport xlwtimport sysfrom 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 Workbookfrom openpyxl.compat import rangefrom openpyxl.cell import get_column_letterfrom openpyxl import load_workbookimport csvimport osimport sysdef 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) |
