blocks|key|716478|text|实际上，您不需要将数据保存在磁盘上的任何地方；openpyxl有一种方法可以做到这一点，尽管它没有很好的文档。很久以前，我使用xlwt创建了像这样的东西，但最近我也使用openpyxl在猎鹰框架中构建了类似的东西。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|716479|将这两者结合在一起，您的代码将类似于：|716480|from+django.http+import+HttpResponse
from+openpyxl+import+Workbook
from+openpyxl.writer.excel+import+save_virtual_workbook


workbook+=+Workbook()
worksheet+=+workbook.active

#+...+worksheet.append(...)+all+of+your+data+...

response+=+HttpResponse(content=save_virtual_workbook(workbook),+mimetype='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')
response['Content-Disposition']+=+'attachment;+filename=myexport.xlsx'
return+response|code-block|syntax|javascript|716481|如果您正在生成更大的文件，我建议您考虑使用StreamingHttpResponse，但我相信这至少会让您开始使用。|716482|这只是一个即兴片段，基于我所做的两个项目的合并，所以它可能不是完全正确的。不过应该很近。“猎鹰”的输出类似于：|716483|response.content_type+=+'application/octet-stream;'
response.set_header('Content-Disposition',+'attachment;+filename=myexport.xlsx')
response.body+=+save_virtual_workbook(workbook)|716484|更新：现在要简单得多，因为我使用openpyxl完成了对旧django-excel-response库的彻底重写！现在可以在这里找到它：https://github.com/tarkatronic/django-excel-response|style|BOLD|CODE|716485|您可以使用pip+install+django-excel-response安装它，并开始使用它作为Django的HttpResponse的替代！所包含的文档很少，欢迎改进/建议。:)|716486|entityMap|0|LINK|mutability|MUTABLE|url|https://bitbucket.org/tarkatronic/django-excel-response|1|http://falconframework.org/|2|https://github.com/tarkatronic/django-excel-response^0|1Y|6|0|2L|2|1|0|0|0|0|0|0|0|3|T|L|1W|1G|2|0|5|X|1L|C|0^^$0|@$1|2|3|4|5|6|7|19|8|@]|9|@$A|1A|B|1B|1|1C]|$A|1D|B|1E|1|1F]]|C|$]]|$1|D|3|E|5|6|7|1G|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|1H|8|@]|9|@]|C|$I|J]]|$1|K|3|L|5|6|7|1I|8|@]|9|@]|C|$]]|$1|M|3|N|5|6|7|1J|8|@]|9|@]|C|$]]|$1|O|3|P|5|H|7|1K|8|@]|9|@]|C|$I|J]]|$1|Q|3|R|5|6|7|1L|8|@$A|1M|B|1N|S|T]|$A|1O|B|1P|S|U]]|9|@$A|1Q|B|1R|1|1S]]|C|$]]|$1|V|3|W|5|6|7|1T|8|@$A|1U|B|1V|S|U]|$A|1W|B|1X|S|U]]|9|@]|C|$]]|$1|X|3|-4|5|6|7|1Y|8|@]|9|@]|C|$]]]|Y|$Z|$5|10|11|12|C|$13|14]]|15|$5|10|11|12|C|$13|16]]|17|$5|10|11|12|C|$13|18]]]]

You don't actually need to save the data anywhere on disk; openpyxl has a way to do this, although it's not very well documented. A long while back, I created <a href="https://bitbucket.org/tarkatronic/django-excel-response" rel="noreferrer">something like this</a> using xlwt, but I recently also built something similar in the <a href="http://falconframework.org/" rel="noreferrer">Falcon</a> framework, using openpyxl.

Putting these two together, your code would look something along the lines of:

<pre><code>from django.http import HttpResponse
from openpyxl import Workbook
from openpyxl.writer.excel import save_virtual_workbook


workbook = Workbook()
worksheet = workbook.active

# ... worksheet.append(...) all of your data ...

response = HttpResponse(content=save_virtual_workbook(workbook), mimetype='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')
response['Content-Disposition'] = 'attachment; filename=myexport.xlsx'
return response
</code></pre>

If you are generating larger files, I would recommend looking into using StreamingHttpResponse, but I believe this will at least get you going.

This is just an off-the-cuff snippet based on a merge of the two project I worked on, so it may not be exactly correct. It should be pretty close though. The output in Falcon looked like:

<pre><code>response.content_type = 'application/octet-stream;'
response.set_header('Content-Disposition', 'attachment; filename=myexport.xlsx')
response.body = save_virtual_workbook(workbook)
</code></pre>

UPDATE:
This is now much easier, as I did a complete rewrite of my old <code>django-excel-response</code> library, using openpyxl! It can now be found here: <a href="https://github.com/tarkatronic/django-excel-response" rel="noreferrer">https://github.com/tarkatronic/django-excel-response</a>

You can install it with <code>pip install django-excel-response</code>, and start using it as an alternative to Django's <code>HttpResponse</code>! There is minimal documentation included, and improvements/suggestions are welcome. :)

blocks|key|1878960|text|这对我来说很管用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1878961|from+openpyxl+import+Workbook,+load_workbook
from+openpyxl.writer.excel+import+save_virtual_workbook

wb+=+Workbook()
...

response+=+HttpResponse(content=save_virtual_workbook(wb),+content_type='application/ms-excel')
response['Content-Disposition']+=+'attachment;+filename=Inform.xlsx'
return+response|code-block|syntax|javascript|1878962|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

this worked for me 

<pre><code>from openpyxl import Workbook, load_workbook
from openpyxl.writer.excel import save_virtual_workbook

wb = Workbook()
...

response = HttpResponse(content=save_virtual_workbook(wb), content_type='application/ms-excel')
response['Content-Disposition'] = 'attachment; filename=Inform.xlsx'
return response
</code></pre>

blocks|key|716535|text|由于save_virtual_workbook将过时，所以我使用了流。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|716536|from+openpyxl+import+Workbook
from+tempfile+import+NamedTemporaryFile

def+exportToExcel(request):
+++workbook+=+Workbook()
+++...

+++with+NamedTemporaryFile()+as+tmp:
++++++workbook.save(tmp.name)
++++++tmp.seek(0)
++++++stream+=+tmp.read()

+++response+=+HttpResponse(content=stream,+content_type='application/ms-excel',+)
+++response['Content-Disposition']+=+f'attachment;+filename=ExportedExcel-{datetime.now().strftime("%25Y%25m%25d%25H%25M")}.xlsx'
+++return+response|code-block|syntax|javascript|716537|entityMap|0|LINK|mutability|MUTABLE|url|https://openpyxl.readthedocs.io/en/stable/tutorial.html#saving-as-a-stream^0|X|1|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

Since save_virtual_workbook will be obsolete, I used <a href="https://openpyxl.readthedocs.io/en/stable/tutorial.html#saving-as-a-stream" rel="noreferrer">stream</a> insted.
<pre><code>from openpyxl import Workbook
from tempfile import NamedTemporaryFile

def exportToExcel(request):
 workbook = Workbook()
 ...

 with NamedTemporaryFile() as tmp:
 workbook.save(tmp.name)
 tmp.seek(0)
 stream = tmp.read()

 response = HttpResponse(content=stream, content_type='application/ms-excel', )
 response['Content-Disposition'] = f'attachment; filename=ExportedExcel-{datetime.now().strftime(&quot;%Y%m%d%H%M&quot;)}.xlsx'
 return response
</code></pre>

I need to provide an excel formatted data from django's database to visitors.

The only way I can think of is with these steps:

<ol>
<li>Extract data from database.</li>
<li>Wrap it with <code>Workbook</code> object from <code>openpyxl</code>.</li>
<li>Save it somewhere temporarily.</li>
<li>Read it again as 'rb'.</li>
<li>return view with <a href="https://stackoverflow.com/a/2938188/4019871">excel's mime type</a>.</li>
<li>Delete excel file on disk. (It's useless now right?)</li>
</ol>

That should do it. But, I think there's another better way to do this. I mean
maybe there's a way to return <code>openpyxl</code> object as <code>HttpResponse</code> directly
without intermediate file medium.

So, my question here is: is it possible to return <code>openpyxl</code>'s <code>Worbook</code>
object? (I'm new with <code>openpyxl</code>)

Return openpyxl workbook object as HttpResponse in django. Is it possible?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我需要从django的数据库向访问者提供excel格式的数据。我唯一能想到的方法就是通过这些步骤：从数据库中提取数据。用Workbook对象从openpyxl包装它。暂时保存在某个地方。再读一遍“rb”。使用返回视图。删除磁盘上的excel文件。(现在没用了，对吧？)这样就行了。但是，我认为还有更好的方法。我的意思是，...

问在django中以HttpResponse的形式返回openpyxl工作簿对象。有可能吗？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在django中以HttpResponse的形式返回openpyxl工作簿对象。有可能吗？EN