excel file upload to MySQL database

64 views
Skip to first unread message

girija sameera

unread,
Jan 13, 2016, 9:30:04 AM1/13/16
to Django users
Hello,
  I am  a Django beginner working on a web application wherein I am required to provide back-end support. I am expected to take an excel file uploaded by the admin from the template , parse the file using available Django libraries and upload it to MySQL database . Also  bulk upload of files needs to be supported.

I would like some suggestions on how to proceed.I would really appreciate links to tutorials and websites.

Thank you,

Girija



 

Larry Martell

unread,
Jan 13, 2016, 10:49:41 AM1/13/16
to django...@googlegroups.com
This is something you'd typically do on the server side from python.
You can use a lib like openpyxl for that
(https://pypi.python.org/pypi/openpyxl)

François Schiettecatte

unread,
Jan 13, 2016, 10:55:03 AM1/13/16
to django...@googlegroups.com
You can also use xlrd to open .xls files if needed:

https://pypi.python.org/pypi/xlrd

François
> --
> You received this message because you are subscribed to the Google Groups "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
> To post to this group, send email to django...@googlegroups.com.
> Visit this group at https://groups.google.com/group/django-users.
> To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CACwCsY4pRdid9H1_XVrF1mVGfPkOz%2Bs4z1-a1aVmpVb2zZrEzg%40mail.gmail.com.
> For more options, visit https://groups.google.com/d/optout.

girija sameera

unread,
Jan 14, 2016, 4:52:03 AM1/14/16
to Django users
 Ok will see that. Also I found this http://django-excel.readthedocs.org/en/latest/

Do you think it would work?

Thank you.

François Schiettecatte

unread,
Jan 14, 2016, 7:12:31 AM1/14/16
to django...@googlegroups.com
Why don’t you try and see.

François
> --
> You received this message because you are subscribed to the Google Groups "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
> To post to this group, send email to django...@googlegroups.com.
> Visit this group at https://groups.google.com/group/django-users.
> To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/447f8e90-5daf-44c9-a376-e4fed8208972%40googlegroups.com.

Derek

unread,
Jan 18, 2016, 3:48:48 AM1/18/16
to Django users
Reply all
Reply to author
Forward
0 new messages