How to upload and process the Excel file in Django

In this article we will discuss how to upload an Excel file and then process the content without storing file on server. One approach could be uploading the file, storing it in upload directory and then reading the file. Another approach could be uploading file and reading it directly from post data without storing it in memory and displaying the data.

We will work with the later approach here.

You may create a new project or work on existing code.

If you are setting up a new project then create a new virtual environment and install Django 2.0 and openpyxl modules in virtual environment using pip.

 

Continue reading “How to upload and process the Excel file in Django”

List of USA states in Python-Django format

In one of previous article we released the list of Indian states in different formats (CSV, List, Set, Model Choice, HTMLSelect) to be used in python-django project. We received few requests to release the USA states in same format. So here we are, presenting to you the states of USA in different Python-Django format.

Continue reading “List of USA states in Python-Django format”

How to upload and process the CSV file in Django

In this article we will discuss how to upload a csv file and then process the content without storing file on server. One approach could be uploading the file, storing it in upload directory and then reading the file. Another approach could be uploading file and reading it directly from post data without storing it in memory and displaying the data.

We will work with the later approach here.

Continue reading “How to upload and process the CSV file in Django”