Retrieving data from an Excel worksheet

Question

How to load data from an Excel sheet into a Django application? I am using a PosgreSQL database as a database.

I want to do this programmatically. The client wants to upload two different lists to the website on a weekly basis, and they do not want to do this in the admin section, they just want the lists to be downloaded from an Excel sheet. Please help, because I'm a little new here.

Answer 1

Take a look at the xlrd package, which allows you to read Excel files in Python. After you read the data, you can do whatever you want with it, including saving it to the database.

http://scienceoss.com/read-excel-files-from-python/

Answer 2

django-batchimport http://code.google.com/p/django-batchimport/ Excel Django. . Django.

, , .

XLRD.

Answer 3

"Excel Python", PyCon US:

" , COM Windows Excel".

http://www.simplistix.co.uk/presentations/python_excel_09/excel-lightning.pdf

Answer 4

? , excel CSV ( csv txt) Postgresql,

copy the_data from '/path/to/csv/MYFILE.txt' DELIMITERS ',' CSV;

Answer 5

. - (CSV - ) - SQL script. http://www.postgresql.org/docs/8.3/static/populate.html

Answer 6

SQLAlchemy, - script, . (http://www.sqlalchemy.org/)

Answer 7

COM excel (.. Windows), . " Excel SQLite" - http://www.saltycrane.com/blog/2007/11/migrating-excel-to-sqlite-using-python/

Answer 8

django-batchimport xlrd, . , , Django. xlrd. . .

, django-batchimport . : http://code.google.com/p/django-batchimport/

Answer 9

Just started using XLRD and it looks very simple and easy to use.

Beware that it does not yet support Excel 2007, so keep in mind your advantage in the 2003 format.