Reading Excel File in Django uploaded using html form

Question

I am learning django framework and trying to read an excel file

I want to upload file using html form(POST Method) and want to read in python for calculations so what should I do really confused ? Code Is Here form.html

<form method="POST" action="minmax_ans.html">{% csrf_tocken %}
   {{form.as_p}}
   <p><b><h2>Upload File</h2></b><p>
   <input type="file" name="file" value="{{ source.title }}">
   <input type="submit">
</form>

views.py

def upload_file(request):
    if request.method == 'POST':
        form = UploadFileForm(request.POST, request.FILES)
        if form.is_valid():
            handle_uploaded_file(request.FILES['file'])
            return HttpResponseRedirect('/success/url/')
    else:
        form = UploadFileForm()
    return render(request, 'upload.html', {'form': form})

I want to do some calculations using data in the file uploaded through html form if it is an excel file and display the result on result.html which I have not created yet because I cannot read the file

Please show what you've tried and what isn't working for you. stackoverflow.com/help/how-to-ask — Ryan Tuosto
– Ryan Tuosto, Commented Apr 10, 2017 at 20:18

S Verma · Accepted Answer · 2019-10-03 14:17:08Z

1

You can do something like this

import pandas as pd
def handle_uploaded_file(f):
    pd.read_excel(f, index_col=0)

Pandas read_excel accepts argument io in str, ExcelFile, xlrd.Book, path object or file-like object.

answered Oct 3, 2019 at 14:17

S Verma

1132 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

spadarian · Accepted Answer · 2017-04-11 08:18:31Z

0

Probably I would start by reading the Django documentation:
https://docs.djangoproject.com/en/1.10/topics/http/file-uploads/

To read the excel file you can use pandas:
http://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_excel.html

answered Apr 11, 2017 at 8:18

spadarian

1,62411 silver badges15 bronze badges

Collectives™ on Stack Overflow

Reading Excel File in Django uploaded using html form

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related