Download file from Django Project root using a button

Question

So, this is the webpage I'm creating atm with Django 1.8:

Want the user to be able to export the data as .csv.

When the user:

writes a subreddit name in the box
presses the button 'Get Data'

What happens:

it's created a test.csv (saved in the root of the project)
data is retrieved using Praw
data is inserted into the .csv
data is rendered for the users to see

The problem now is: I want the button with 'Export to Excel', to download the generated file from the root of the Django project.

This is for the button:

 <form class="export_excel" id="login_form" action="/app/export">
    {% csrf_token %}
    <button class="btn btn-lg btn-primary btn-block" value="Export to Excel" type="submit">Export To Excel</button>
 </form>

This is in app/views.py:

def export(request):

    filename = "test.csv" # this is the file people must download

    response['Content-Disposition'] = 'attachment; filename=' + filename
    response['Content-Type'] = 'application/vnd.ms-excel; charset=utf-16'
    return response

This is in app/urls.py:

# app/urls.py
from django.conf.urls import url
from . import views

# Create your urls here.
urlpatterns = [
(...)
  url(r'^export/$', views.export, name='export')
]

This is the error I'm getting when clicking the button:

Question is: How can I make the user export the file using the button? What am I doing wrong?

Thanks in advance for your help / guidance

Handy links:

I don't know about the reddit stuff, but this approach seems awfully complicated, why are you saving the generated file? Have looked at examples like this one http://stackoverflow.com/questions/5146539/streaming-a-csv-file-in-django were the .csv is created and directly sent to the user (or even streamed for larger files)? — andipla, Mar 08 '17 at 12:49
It was the only solution I could think of. No, thank you for sharing. I'm going to look now @andipla — Tiago Martins Peres 李大仁, Mar 08 '17 at 12:52

nik_m · Accepted Answer · 2018-10-20T18:56:28.833

4

You must first create the response object in order to assign headers to it.

def export(request):
    filename = "test.csv" # this is the file people must download
    with open(filename, 'rb') as f:
        response = HttpResponse(f.read(), content_type='application/vnd.ms-excel')
        response['Content-Disposition'] = 'attachment; filename=' + filename
        response['Content-Type'] = 'application/vnd.ms-excel; charset=utf-16'
        return response

Taken from here

edited Oct 20 '18 at 18:56

answered Mar 08 '17 at 12:41

nik_m

10,549
4
39
52

Great, it's downloading. Still, this is downloading the code of the page where this button is at, without the area with the data. I just wanted the data part, that's why mentioned to get the file that was already in the server – Tiago Martins Peres 李大仁 Mar 08 '17 at 12:50
2

thank you, this works fine. Just do a little edit to `response = HttpResponse(f.read(), content_type='application/vnd.ms-excel')`, you have an extra 'h' – Tiago Martins Peres 李大仁 Mar 08 '17 at 13:03

Download file from Django Project root using a button

1 Answers1

Linked