python各种excel写⼊⽅式的速度对⽐经过实验，新建⼀个excel表格，该表格拥有7个sheet，每个sheet有800条数据，其中最后⼀个sheet为空。
⾸先使⽤openpyxl进⾏写⼊操作，代码如下：book = openpyxl.Workbook()auths = Auth.objects.filter(owner_id=1)filename = '导出数据'for auth in auths:sheet = book.create_sheet(, index = 0)sheet.append([_("书名"),_("作者"),_("译者"),_("出版社"),_("序列号"),_("总页数"),])objs = Noneobjs = Book.objects.filter(owner_id=auth.id)for u in objs:data = []data.append()data.append()data.append(u.translator)data.append(u.press)data.append(u.serializer)data.append(u.page)sheet.append(data)return ExcelBookResponse(book, filename)使⽤xlwt写⼊数据：book = xlwt.Workbook()auths = Auth.objects.filter(owner_id=1)filename = '导出数据'for auth in auths:sheet = book.add_sheet()sheet.write(0, 0, _("书名"))sheet.write(0, 1, _("作者"))sheet.write(0, 2, _("译者"))sheet.write(0, 3, _("出版社"))sheet.write(0, 4, _("序列号"))sheet.write(0, 5, _("总页数"))i = 1objs = Noneobjs = Book.objects.filter(owner_id=auth.id)for u in objs:sheet.write(i, 0, )sheet.write(i, 1, )sheet.write(i ,2,u.translator)sheet.write(i ,3,u.press)sheet.write(i, 4, u.serializer)sheet.write(i, 5, u.page)i += 1return ExcelBookResponse(book, filename)使⽤XlsxWriter写⼊数据：book = xlsxwriter.Workbook(output)auths = Auth.objects.filter(owner_id=1)for auth in auths:sheet = book.add_worksheet()header = [_("书名"),_("作者"),_("译者"),_("出版社"),_("序列号"),_("总页数"),]sheet.write_row("A1", header)objs = Book.objects.filter(owner_id=auth.id)i = 1for u in objs:sheet.write(i, 0, )sheet.write(i, 1, )sheet.write(i ,2,u.translator)sheet.write(i ,3,u.press)sheet.write(i, 4, u.serializer)sheet.write(i, 5, u.page)i += 1book.close()file_ext = 'xlsx'mimetype = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'# self['Content-Disposition'] = 'attachment; filename*=UTF-8\'\'"{2}.{1}"; filename="{0}.{1}"'.format(filename.replace('"', '\"'), file_ext, urllib.parse.quote(filename.replace('"', '\"'))).encode('utf8') return HttpResponse(content=output.getvalue(), content_type=mimetype)三者的时间⽐较（两种⽅式的⽂件内容是⼀样的）：openpyxl: ⽂件⼤⼩为110.75kb, 平均时间⼤约为570msxlwt: ⽂件⼤⼩为505.91kb，平均时间⼤约为440msXlsxWrite: ⽂件⼤⼩为109.28kb，平均时间⼤约为500msxlwt写⼊的⾏数有限制，因此对于较⼤的⽂件来说，XlsxWrite的速度较快⼀点补充知识：python写⼊excel⽂件太慢如何解决-python往excel写⼊⼤量数据⽬前⽤的openpyxl，从数据库获取8W⾏的数据通过openpyxl写⼊excel，要花费接近8分钟，这也太慢了，⽤kettle的插件秒进，python有什么⽅法能提升速度么，或者openpyxl能批量插⼊么，按⾏效率太低了#!/usr/bin/python# -*- coding: UTF-8 -*-from openpyxl import Workbook as wbookdef xlsx(filename, rows_info, sheet='Result'):if filename and sheet:wb = wbook()_sheet = wb.active_sheet.title = sheetrow = _sheet.max_rowfor line in rows_info:if isinstance(line, str):row_list = [line]elif isinstance(line, dict):row_list = list(line.values())else:try:row_list = list(line)except:row_list = []for col in range(0, len(row_list)):col_info = row_list[col]_sheet.cell(row, col + 1, col_info)row += 1wb.save(filename)else:return '⽂件和sheet不能为空'以上这篇python各种excel写⼊⽅式的速度对⽐就是⼩编分享给⼤家的全部内容了，希望能给⼤家⼀个参考，也希望⼤家多多⽀持。
