Although it may be possible, you are not supposed to be creating models on the
fly. This isn't peculiar to Django; it violates the good practices of relational
database systems. You may be able to accomplish what you want with something
like this:
class Spreadsheet(models.Model):
user = ...
...
class Cell(models.Model):
spreadsheet = models.ForeignKey(Spreadsheet)
row = models.PositiveIntegerField()
column = models.PositiveIntegerField()
content = models.TextField(blank=True)
class Meta:
unique_together = (spreadsheet, row, column)
Regards,
A.
Antonis Christofides
http://djangodeployment.com
On 2017-04-21 09:39, [email protected] wrote:
>
> I like to create a site where users upload their excel (1 or many) and use the
> platform to query the data anytime they login.
>
> So can someone help how can i do the below:
>
>
> 1. How can i create a model for any excel table or shapefile at run time and
> build ORM before saving it to database? Because its not possible to imagine
> the column names and their data types.
>
>
> 2. Also , like to know a simple strategy of loading those tables in database
> instead of loading each imported excel table as different table in the
> database.
>
> --
> 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 [email protected]
> <mailto:[email protected]>.
> To post to this group, send email to [email protected]
> <mailto:[email protected]>.
> 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/07f053aa-508f-450c-946a-0b3fcfdbdff4%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/07f053aa-508f-450c-946a-0b3fcfdbdff4%40googlegroups.com?utm_medium=email&utm_source=footer>.
> For more options, visit https://groups.google.com/d/optout.
--
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 [email protected].
To post to this group, send email to [email protected].
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/428613e0-b580-aa58-301f-de3f96be3bed%40djangodeployment.com.
For more options, visit https://groups.google.com/d/optout.
