openpyxl 写 excel 文件遇到问题

from django.http import HttpResponse
from openpyxl import Workbook, load_workbook
from openpyxl.writer.excel import save_virtual_workbook

class ExcelTableObj(object):
    def __init__(self, file_name=None, write_only=False):
        if file_name:
            self.file_name = file_name
            self.wb = load_workbook(file_name)
        else:
            self.wb = Workbook(write_only=write_only)
        self.write_only = write_only

    def fix_save_excel(self, header, sheet_name, data_lists):
        ws = self.wb.create_sheet(title=sheet_name)
        ws.append(header)
        for data in data_lists:
            ws.append(data)



# Django view
excel = ExcelTableObj(write_only=True)


try:
    excel.fix_save_excel(title, sheetname, data_lists)
except Exception as e:
    import traceback as t; t.print_exc()
    logger.error(repr(e))

finally:
    response = HttpResponse(save_virtual_workbook(excel.wb),
                            content_type='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')
    response['Content-Disposition'] = 'attachment; filename={}'.format(filename)

因为 excel 文件很大, 所以使用write_only模式