如何在django中导出excel文件

Question

我需要使用模板导出数据的帮助。我安装了django-import-export并将其添加到管理面板，现在我只能从管理面板导出数据。我想知道如何使用模板导出excel文件。

Answer 1

这应该可以让你开始：

import StringIO
import xlsxwriter
from django.http import HttpResponse

def export_page(request):
    # create our spreadsheet.  I will create it in memory with a StringIO
    output = StringIO.StringIO()
    workbook = xlsxwriter.Workbook(output)
    worksheet = workbook.add_worksheet()
    worksheet.write('A1', 'Some Data')
    workbook.close()

    # create a response
    response = HttpResponse(content_type='application/vnd.ms-excel')

    # tell the browser what the file is named
    response['Content-Disposition'] = 'attachment;filename="some_file_name.xlsx"'

    # put the spreadsheet data into the response
    response.write(output.getvalue())

    # return the response
    return response

Answer 2

我在新版本的Django上尝试了同样的方法，经过反复试验，我发现这是可行的。

import io
import xlsxwriter

def excelreport(request):

  buffer = io.BytesIO()
  workbook = xlsxwriter.Workbook(buffer)
  worksheet = workbook.add_worksheet()
  worksheet.write('A1', 'Some Data')
  workbook.close()
  buffer.seek(0)

  return FileResponse(buffer, as_attachment=True, filename='report.xlsx')