Hello! I import Excel files with pyExcelerator
http://sourceforge.net/projects/pyexcelerator It works well with multiple sheets and supports all formats up to office 2003. Yours, Guillaume. On Mon, 2007-05-14 at 06:00 -0400, Todd O'Bryan wrote: > Check out Xlrd. It will import Excel files and change them into a list > of lists. > > http://cheeseshop.python.org/pypi/xlrd/0.5.2 > > Todd > > On Mon, 2007-05-14 at 11:25 +0200, Aidas Bendoraitis wrote: > > Hello, Dmitry! > > > > You could save the excel sheet as comma separated values and then read > > and parse them line-by-line using python. > > > > For each category (which is one of the columns) you can get_or_create > > a category record in the database and assign that as a foreign key or > > many to many relationship to the record of the main item. > > > > All the further details depend on your models and business requirements. > > > > Regards, > > Aidas Bendoraitis aka Archatas > > > > > > > > On 5/12/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > > > Hello, everyone! > > > > > > I want to implement some sort of importing data into my database from > > > excel. And i have a problem: this xls tables are huge and needs to be > > > normalized to relation structure, in other words i want to torn one > > > excel table to many with FK relationships between them, but i dunno > > > how to do this: in my python import function, or some kind of SQL > > > procedure, or there are software, which can do that. Please, advice > > > > > > Regards, Dmitry Shevchenko. > > > > > > > > > > > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
