xls_csv

把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 <xlsx file name>')
    else:
    xlsx2csv(sys.argv[1])
    sys.exit(0)