How to get data from django model to the excel sheet.

47 views
Skip to first unread message

Ashutosh Mishra

unread,
Jul 6, 2020, 6:59:29 AM7/6/20
to Django users
I want to get the data from the django model contans(name,age,photo) on a excel sheet.
How can i do that.

sum abiut

unread,
Jul 6, 2020, 7:59:59 AM7/6/20
to django...@googlegroups.com
You can try this export data to excel file
Sum,

On Mon, Jul 6, 2020 at 7:00 PM Ashutosh Mishra <ashutosh...@gmail.com> wrote:
I want to get the data from the django model contans(name,age,photo) on a excel sheet.
How can i do that.

--
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...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/b9ad3b60-2c0a-43dc-bdc6-6a67f8a88826n%40googlegroups.com.


mohamed khaled

unread,
Jul 6, 2020, 8:02:53 AM7/6/20
to django...@googlegroups.com
You can serialized your data and then use any tools to export the data as csv for example. 

On Mon, Jul 6, 2020, 9:00 AM Ashutosh Mishra <ashutosh...@gmail.com> wrote:
I want to get the data from the django model contans(name,age,photo) on a excel sheet.
How can i do that.

--

Ashutosh Mishra

unread,
Jul 6, 2020, 8:06:17 AM7/6/20
to Django users
What if I have an image field too,how to do that

Damanjeet Singh

unread,
Jul 6, 2020, 8:24:17 AM7/6/20
to django...@googlegroups.com
Please see handsontable.com.

I have been using it for my project.

On Mon, Jul 6, 2020 at 9:06 AM Ashutosh Mishra <ashutosh...@gmail.com> wrote:
What if I have an image field too,how to do that

--
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...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/9bf3cc78-00bd-4a8f-a6b7-90344f0bded7o%40googlegroups.com.

Ashutosh Mishra

unread,
Jul 6, 2020, 8:27:33 AM7/6/20
to django...@googlegroups.com

But It is for js,react,angular, how can I place that in django project

On Jul 6, 2020 1:54 PM, "Damanjeet Singh" <mailt...@gmail.com> wrote:
Please see handsontable.com.

I have been using it for my project.

On Mon, Jul 6, 2020 at 9:06 AM Ashutosh Mishra <ashutosh...@gmail.com> wrote:
What if I have an image field too,how to do that

--
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+unsubscribe@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/9bf3cc78-00bd-4a8f-a6b7-90344f0bded7o%40googlegroups.com.

--
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAGLHGi5_9zX%2BLkywRH9GB_hKLJTBRRjmGBw1aCrYSW5WGOj-6Q%40mail.gmail.com.

Luciano Martins

unread,
Jul 6, 2020, 9:00:24 AM7/6/20
to Django users
To work with excell within Django projects we use the openxl  library, but you can't use it directly, you need to build scripts that bring you what you want.

Vishesh Mangla

unread,
Jul 6, 2020, 9:00:58 AM7/6/20
to django...@googlegroups.com, Ashutosh Mishra

@Ashutosh Mishra I think reading your sql table with pandas and using to_excel/to_csv would be great in this case. If you are worried about the images. First of all I don’t know how you are storing your images. One method to store an image is to convert it to a very long base64 string and store it in the database. Then whenever you want to show it use can use that base64 string. Web browsers can understand base64 strings. But using base64 allows anyone to just copy your image so be careful. You can otherwise always decode back from base64 to normal image always.

 

Sent from Mail for Windows 10

Vishesh Mangla

unread,
Jul 6, 2020, 9:17:42 AM7/6/20
to django...@googlegroups.com

 

Sent from Mail for Windows 10

 

From: Ashutosh Mishra
Sent: 06 July 2020 13:56
To: django...@googlegroups.com
Subject: Re: How to get data from django model to the excel sheet.

 

But It is for js,react,angular, how can I place that in django project

On Jul 6, 2020 1:54 PM, "Damanjeet Singh" <mailt...@gmail.com> wrote:

Please see handsontable.com.

 

I have been using it for my project.

 

On Mon, Jul 6, 2020 at 9:06 AM Ashutosh Mishra <ashutosh...@gmail.com> wrote:

What if I have an image field too,how to do that

--
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...@googlegroups.com.

--
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...@googlegroups.com.

--

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...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAGDmY671qKxoEUL%3DjEWQ7Xso4Opn74W3jh3dtD2Zy9jgvEpjtw%40mail.gmail.com.

 

Reply all
Reply to author
Forward
0 new messages