Convert the python script to xls (xlsx) to csv

This article mainly introduces the python script to convert xls (xlsx) to csv. For more information, see # xls_csv

Convert xls and xlsx files to csv files.

# Use
Python xls2csv. py

# -*- 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)

I will share with you a piece of code.

Xlsx file parsing: csv file format generated by openpyxl Library: csv

Python # coding: UTF-8 # dependency on openpyxl Library: 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 workflow (): # Each sheet is output to a csv file. The file name uses the xlsx file name and the sheet name as '_' to connect csv_filename = '{xlsx}_{sheet}.csv '. format (xlsx = OS. path. splite Xt (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_cont Ainer) csv_file.close () failed t Exception as e: print (e) if _ name _ = '_ main _': if len (sys. argv )! = 2: print ('usage: xlsx2csv
 
  
') Else: xlsx2csv (sys. argv [1]) sys. exit (0)