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 -~----------~----~----~----~------~----~------~--~---
