python脚本实现xls(xlsx)转成csv
#xls_csv
把xls,xlsx格式的文档转换成csv格式
#使用
pythonxls2csv.py<xlsorxlsxfilepath>
#-*-coding:utf-8-*-
importxlrd
importxlwt
importsys
fromdatetimeimportdate,datetime
defread_excel(filename):
workbook=xlrd.open_workbook(filename)
#printsheet2.name,sheet2.nrows,sheet2.ncols
sheet2=workbook.sheet_by_index(0)
forrowinxrange(0,sheet2.nrows):
rows=sheet2.row_values(row)
def_tostr(cell):
iftype(u'')==type(cell):
return"\"%s\""%cell.encode('utf8')
else:
return"\"%s\""%str(cell)
print','.join([_tostr(cell)forcellinrows])
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/
fromopenpyxlimportWorkbook
fromopenpyxl.compatimportrange
fromopenpyxl.cellimportget_column_letter
fromopenpyxlimportload_workbook
importcsv
importos
importsys
defxlsx2csv(filename):
try:
xlsx_file_reader=load_workbook(filename=filename)
forsheetinxlsx_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]
forrowinsheet_ranges.rows:
row_container=[]
forcellinrow:
iftype(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()
exceptExceptionase:
print(e)
if__name__=='__main__':
iflen(sys.argv)!=2:
print('usage:xlsx2csv<xlsxfilename>')
else:
xlsx2csv(sys.argv[1])
sys.exit(0)