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)