openpyxl写excel文件遇到问题

uwsgi

Django

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)

write_only