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, sivakumar...@digicollect.com 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 django-users+unsubscr...@googlegroups.com
> <mailto:django-users+unsubscr...@googlegroups.com>.
> To post to this group, send email to django-users@googlegroups.com
> <mailto:django-users@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/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 django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@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/428613e0-b580-aa58-301f-de3f96be3bed%40djangodeployment.com.
For more options, visit https://groups.google.com/d/optout.
