Unable to get images from django model to excel sheet

yes i am able to retrieve in admin pannel,while downloading the excel sheet i am getting the root address of the image in the excel sheet under image

obj.Image1.url=getting the url of the root location of image.

are your getting 'media/images/{filename}.jpg' ? . If yes then you need to join os.path.join(BASE_DIR, 'media') in your script so that you will get full path of image in local PC which will have the location of the image.

I have done this in my settings.py, Or do I need to add some other place,

you have to do in your excel download script, because that script doesnt have any connection to your web server. As you are trying to download files from Web server to desktop. Think about like this, ImageField if you are using in frontend then it has be render from web server but we are trying to download the file from webserver to desktop, then we have to provide everything explicitly in order to download the files.Also can you send me the output you are getting when you use "obj.image.url" option

@Bhavana,thaks for ur help, can we discuss this tomorrow,as I am unable to get to my system.

And where do I need to add is.path ,in my script?,

Below are the sample one I used in one of my project but this one CSV,
def export_creds_csv(request): user_details = request.user

    export_obj = Task.objects.create(user=user_details)


    response = HttpResponse(content_type='text/csv')
    response['Content-Disposition'] = 'attachment; filename="Task.csv"'

    writer = csv.writer(response)
    writer.writerow(['Name', 'Server', ' Environment',
         'Name','Password'])

    creds= Some.objects.all().values_list('Applnname', 'Applnservername', 'Applnenv',
         'Applnusername','Applnpassword')
    for cred in creds:
        writer.writerow(cred)

    return response

sorry i misunderstood your question, check the above sample code, if it helps.

What u posted above is right and my code is also working,I am getting all the data on excel sheet as required Except the image,I want image on excel sheet,obj.Image11.URL=media/images/{filename}.jpg'

can you show your settings MEDIA variable & also project urls.py file info. seems like issue in your settings to grab the image.url path.

OK,let me try

You could also check this in your Django shell just like below,

from blogs.models import Post p = Post.objects.first() p.blog_image <ImageFieldFile: default.jpg> p.blog_image.url
If you are getting the full path, then you should able to get the full path in your download as well.

or you can use obj.image.path this will also return the path as long if you are not using any storage like AWS etc

STATIC_URL = '/static/'

MEDIA_ROOT = os.path.join(BASE_DIR, 'media/') MEDIA_URL = '/media/'

urls.py

from rest_framework import routers from office.views import * from django.conf.urls import url from django.conf.urls.static import static

router = routers.DefaultRouter()

router.register(r'Task', TaskViewSet,basename='Task') urlpatterns = router.urls

obj.image.path=home/ashu/Desktop/django/task/media/media/images/Most-Popular-Sports-in-America.jpg

did you tried the 2 options which i have posted before one on Django shell and another is path?. Check below sample code,

r = Room.objects.first() r.image <ImageFieldFile: cover_pics.JPG> r.image.url '/media/cover_pics.JPG' r.image.path 'C:\Gui_Django\hotelmanagement\media\cover_pics.JPG'

project.urls.py looks like below ,
if settings.DEBUG: urlpatterns += static(settings.MEDIA_URL, document_root=settings.MEDIA_ROOT)
settings.py file ,
STATIC_ROOT = os.path.join(BASE_DIR, 'static') STATIC_URL = '/static/'

MEDIA_ROOT = os.path.join(BASE_DIR, 'media')
MEDIA_URL = '/media/'

using shell getting media/images/Most-Popular-Sports-in-America.jpg

@Admin tried all,output i still same

In both conditions I am getting only the URL of the image,not the image on excel sheet

Id Name Image1 Image2 Date 1 Ashutosh /home/ashu/Desktop/django/task/media/media/images/Most-Popular-Sports-in-America.jpg /home/ashu/Desktop/django/task/media/media/images/Most-Popular-Sports-in-America_FC5tPy0.jpg 2020-07-01 2 Sumit /home/ashu/Desktop/django/task/media/media/images/Most-Popular-Sports-in-America_PscVBTH.jpg /home/ashu/Desktop/django/task/media/media/images/Most-Popular-Sports-in-America_ZdsbkXn.jpg 2020-06-26

hey from django we only able to download the URL, you have to do embedding the image in excel outside. Not from django. we are download the model as a data right?..At least i never see this before. excel

Can u tell mW how can I do this,its my task

After the download excel you can do by some sort of script or vba. You can refer the link which I sent

@Admin what you posted about excel,that is not as per requirement.I have searched a lot about this,not getting the desired result Could you suggest something else

As i mentioned, there is no straight forward approach to display image in excel from django. Django return the data in URL or image path, in excel you have to do some kind of customization to display as image.

import openpyxl

wb = openpyxl.Workbook() ws = wb.worksheets[0] img = openpyxl.drawing.image.Image('test.jpg') img.anchor(ws.cell('A1')) ws.add_image(img) wb.save('out.xlsx')

i found this,i have tried this its working . will it work there,or as u mentioned django return only the url ,we cannot directly post image there.

The options we tried it should work , but it will write the file path only. But seems like you are requirement is showing that image in excel right?. That option as far as I know , we will not be able to do that when we write the excel from Django. but after the excel download , we can write script/VBA script to handle it to display the image. May be if you find any info , how to display the image in excel from Django download , then please post the details it would help others as well.

you would not belive i have been trying this for last 20 days,i have posted this question on every website ,whatsapp group,telegram group,where i could get response,but unfurtunately all void.i will give some more time on this.Anyways thanks for your help.If i get the result i will post here.

Meanwhile I will also search from my end. If i find any info keep you posted here.

http://my-django-python.blogspot.com/2015/05/how-to-create-excel-file-with-images.html

see this for once,i am not getting this completely

we need to convert the image url to the image again,that is the issue

https://stackoverflow.com/questions/62876915/unknown-url-typ-media-photo-ashu-jpg-django hey admin just see this,just solve this,resolve this .

We dont understand. why should we resolve this issue in Stack Overflow?.. As I mentioned if you find answer, you can posted here so that it would help somebody. But as far as I know there is no straight forward approach as you expected. So we are closing the ticket from our end.

Sry, it would not happen again,,

hey admin,i got the iage on excel sheet,finally done,need some time to get complete output,but my initial problem has solved.i will share the code here to help everyone

Yes pls share the code here