python脚本实现xls(xlsx)转成csv

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

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