django 导出 excel 问题 求助 - V2EX
推荐学习书目
Learn Python the Hard Way
Python Sites
PyPI - Python Package Index
http://diveintopython.org/toc/index.html
Pocoo
值得关注的项目
PyPy
Celery
Jinja2
Read the Docs
gevent
pyenv
virtualenv
Stackless Python
Beautiful Soup
结巴中文分词
Green Unicorn
Sentry
Shovel
Pyflakes
pytest
Python 编程
pep8 Checker
Styles
PEP 8
Google Python Style Guide
Code Style from The Hitchhiker's Guide
dwadewyp

django 导出 excel 问题 求助

  •  
  •   dwadewyp Sep 16, 2020 2220 views
    This topic created in 2064 days ago, the information mentioned may be changed or developed.
    我想实现 通过调取 django 的 api,然后下载一个 excel 文件, 不过目前遇到的情况是,返回了乱码的字节流,并不是文件,求助
    13 replies    2020-09-22 16:14:54 +08:00
    manzhiyong
        1
    manzhiyong  
       Sep 16, 2020
    from openpyxl import Workbook
    ....
    ....
    wb = Workbook()
    .....
    ......
    respOnse= HttpResponse(content_type='application/msexcel')
    response['Content-Disposition'] = 'attachment; filename=xxx.xls'
    wb.save(response)
    return response
    dwadewyp
        2
    dwadewyp  
    OP
       Sep 16, 2020
    @manzhiyong 我就是这么做的。。。 通过 postman 返回的是乱码的字节流
    dwadewyp
        3
    dwadewyp  
    OP
       Sep 16, 2020
    @manzhiyong respOnse= HttpResponse(content_type='application/ms-excel')
    response['Content-Disposition'] = 'attachment; filename="ThePythonDjango.xls"'
    ws.save(response)
    return response
    bolide2005
        4
    bolide2005  
       Sep 16, 2020
    content type 改成 application/x-xls 试试?
    manzhiyong
        5
    manzhiyong  
       Sep 16, 2020
    dwadewyp
        6
    dwadewyp  
    OP
       Sep 16, 2020
    @manzhiyong 感谢
    sunmlight
        7
    sunmlight  
       Sep 16, 2020
    有可能是文件名的原因, 可以 urlquote 转一下文件名
    Erroad
        8
    Erroad  
       Sep 16, 2020
    .xls Microsoft Excel application/vnd.ms-excel
    .xlsx Microsoft Excel (OpenXML) application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
    renmu123
        9
    renmu123  
       Sep 16, 2020 via Android
    你用 requests 求理一下文件看
    Erroad
        10
    Erroad  
       Sep 16, 2020
    这是用 google 搜到的 mdn 对 xls,slsx mime 类型的描述,但是怀疑也可能不是这个原因?
    hushao
        11
    hushao  
       Sep 17, 2020 via iPhone
    你用 postman 看二进制文件当然是乱码...
    vegetableChick
        12
    vegetableChick  
       Sep 22, 2020
    postman 不是可以直接 post_and_save 么?
    dwadewyp
        13
    dwadewyp  
    OP
       Sep 22, 2020
    @vegetableChick 已解决
    About     Help     Advertise     Blog     API     FAQ     Solana     3072 Online   Highest 6679       Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 38ms UTC 15:04 PVG 23:04 LAX 08:04 JFK 11:04
    Do have faith in what you're doing.
    ubao msn snddm index pchome yahoo rakuten mypaper meadowduck bidyahoo youbao zxmzxm asda bnvcg cvbfg dfscv mmhjk xxddc yybgb zznbn ccubao uaitu acv GXCV ET GDG YH FG BCVB FJFH CBRE CBC GDG ET54 WRWR RWER WREW WRWER RWER SDG EW SF DSFSF fbbs ubao fhd dfg ewr dg df ewwr ewwr et ruyut utut dfg fgd gdfgt etg dfgt dfgd ert4 gd fgg wr 235 wer3 we vsdf sdf gdf ert xcv sdf rwer hfd dfg cvb rwf afb dfh jgh bmn lgh rty gfds cxv xcv xcs vdas fdf fgd cv sdf tert sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf shasha9178 shasha9178 shasha9178 shasha9178 shasha9178 liflif2 liflif2 liflif2 liflif2 liflif2 liblib3 liblib3 liblib3 liblib3 liblib3 zhazha444 zhazha444 zhazha444 zhazha444 zhazha444 dende5 dende denden denden2 denden21 fenfen9 fenf619 fen619 fenfe9 fe619 sdf sdf sdf sdf sdf zhazh90 zhazh0 zhaa50 zha90 zh590 zho zhoz zhozh zhozho zhozho2 lislis lls95 lili95 lils5 liss9 sdf0ty987 sdft876 sdft9876 sdf09876 sd0t9876 sdf0ty98 sdf0976 sdf0ty986 sdf0ty96 sdf0t76 sdf0876 df0ty98 sf0t876 sd0ty76 sdy76 sdf76 sdf0t76 sdf0ty9 sdf0ty98 sdf0ty987 sdf0ty98 sdf6676 sdf876 sd876 sd876 sdf6 sdf6 sdf9876 sdf0t sdf06 sdf0ty9776 sdf0ty9776 sdf0ty76 sdf8876 sdf0t sd6 sdf06 s688876 sd688 sdf86