You can use the Fixtures feature
First, pass to csv your spreadsheet
Then, you have in mind the model or set of models
ModelA
ModelB
The fields, the data type for every field.
Then, convert to a file of JSON to load with the fixture command.
I can share with you my code that do that:
first , check your excel file , see what are the columns types ..
then , make a model in django models.py and choose model fields to be the
same type as each column in the excel file ..
in your views.py make a function that will read the excel file from the
file location on your machine ..
in this
Thanks Derek for this.
On Friday, 8 May 2020 19:20:31 UTC+5:30, Derek wrote:
>
> If you can, use an existing app:
>
> https://github.com/wq/django-data-wizard
>
>
> On Friday, 8 May 2020 14:57:43 UTC+2, Kasper Laudrup wrote:
>>
>> Hi Ratnadeep,
>>
>> On 08/05/2020 14.03, ratnadeep ray wrote:
Hi Kasper,
I want to read the data from excel and the retrieved data should be pushed
to a DB, in my case it's MySQL.
I believe the steps mentioned in the link
https://www.geeksforgeeks.org/reading-excel-file-using-python/ , should be
written in the views.py file. Am I right?
Please
If you can, use an existing app:
https://github.com/wq/django-data-wizard
On Friday, 8 May 2020 14:57:43 UTC+2, Kasper Laudrup wrote:
>
> Hi Ratnadeep,
>
> On 08/05/2020 14.03, ratnadeep ray wrote:
> > Hi all,
> >
> > Can anyone let me know how to push the fetched data from an excel to any
Hi Ratnadeep,
On 08/05/2020 14.03, ratnadeep ray wrote:
Hi all,
Can anyone let me know how to push the fetched data from an excel to any
DB using Django?
It's not very clear what you mean by "the fetched data". Have you
fetched some data already? In which format?
If you need to extract
Hi all,
Can anyone let me know how to push the fetched data from an excel to any DB
using Django?
--
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
7 matches
Mail list logo
