在 Internet Explorer 中使用 django 和 xlwt 提供动态生成的 MS Excel 文件失败

发布于 2024-11-08 08:05:28 字数 982 浏览 0 评论 0原文

我正在尝试使用 xlwt 从我的 django 站点上的数据库内容创建 MS-Excel 文件。

我在 stackoverflow 上看到了几个解决方案，特别是这个链接： django excel xlwt

和这个 django 片段： http://djangosnippets.org/snippets/2233/

这些示例适用于 Firefox，但不适用于互联网浏览器。屏幕上没有提示打开或保存文件，而是出现一堆飘忽不定的垃圾。看来IE认为响应是html。

这是我的视图函数：

def exportexcel(request):
    from xlwt import Workbook

    wb = Workbook()
    ws = wb.add_sheet('Sheetname')
    ws.write(0, 0, 'Firstname')
    ws.write(0, 1, 'Surname')
    ws.write(1, 0, 'Hans')
    ws.write(1, 1, 'Muster')

    fname = 'testfile.xls'
    response = HttpResponse(mimetype="application/ms-excel")
    response['Content-Disposition'] = 'attachment; filename=%s' % fname

    wb.save(response)

    return response

我在 IE 8 中看到了这种行为。

对于为什么这在 Internet Explorer 中不起作用有什么建议吗？

谢谢。

原文

I am trying to use xlwt to create MS-Excel files from the contents of the database on my django site.

I have seen several solutions here on stackoverflow, in particular this link: django excel xlwt

and this django snippet: http://djangosnippets.org/snippets/2233/

These examples work in firefox, but not in Internet Explorer. Instead of getting prompted to open or save a file, a bunch of wingding junk appears on the screen. It seems that IE thinks the response is html.

Here is my view function:

def exportexcel(request):
    from xlwt import Workbook

    wb = Workbook()
    ws = wb.add_sheet('Sheetname')
    ws.write(0, 0, 'Firstname')
    ws.write(0, 1, 'Surname')
    ws.write(1, 0, 'Hans')
    ws.write(1, 1, 'Muster')

    fname = 'testfile.xls'
    response = HttpResponse(mimetype="application/ms-excel")
    response['Content-Disposition'] = 'attachment; filename=%s' % fname

    wb.save(response)

    return response

I am seeing this behavior in IE 8.

Any suggestions as to why this isn't working in Internet Explorer?

Thanks.

分享到QQ

分享到微博