Created
August 16, 2012 02:11
-
-
Save imkevinxu/3365661 to your computer and use it in GitHub Desktop.
Django code to read uploaded CSV file
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<form action="{% url %}" method="post" enctype="multipart/form-data">{% csrf_token %} | |
<input type="file" name="csv_file" /> | |
<input type="submit" value="Upload" /> | |
</form> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
def index(request): | |
if request.POST and request.FILES: | |
csvfile = request.FILES['csv_file'] | |
dialect = csv.Sniffer().sniff(codecs.EncodedFile(csvfile, "utf-8").read(1024)) | |
csvfile.open() | |
reader = csv.reader(codecs.EncodedFile(csvfile, "utf-8"), delimiter=',', dialect=dialect) | |
return render(request, "index.html", locals()) |
Can you help me with code for reading xml file
How to use this?
Tried this, but using "import csv" caused ALL links to views in that views.py file to be treated as download links (i.e. clicking on a link that corresponds to a view in that views.py file results in the HTML code for that view to be downloaded).
@lopezayl
Not sure if that will be the case, but if that really happens you have to "import csv" from within the views.
fails...
fails
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
For us newbies...
Note that you have to;
import csv
import codecs