python xlsxwriter生成图片保存_python – XlsxWriter对象保存为http响应,以在Django中创建下载...

我想你在问如何使用xlsxwriter在内存中创建一个excel文件，并通过HttpResponse返回。以下是一个例子：

try:

import cStringIO as StringIO

except ImportError:

import StringIO

from django.http import HttpResponse

from xlsxwriter.workbook import Workbook

def your_view(request):

# your view logic here

# create a workbook in memory

output = StringIO.StringIO()

book = Workbook(output)

sheet = book.add_worksheet('test')

sheet.write(0, 0, 'Hello, world!')

book.close()

# construct response

output.seek(0)

response = HttpResponse(output.read(), mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")

response['Content-Disposition'] = "attachment; filename=test.xlsx"

return response

希望有帮助。