Export image to excel issue

Posted by: guptadeepali39 on 21 November 2017, 12:20 pm EST

    • Post Options:
    • Link

    Posted 21 November 2017, 12:20 pm EST

    Hi,

    I want logo(image) in my exported excel file. For this I used backgroundImage property to my cell and put the image but it is not getting exported , rest all stuff is coming in exported excel.

    Please guide me how can I export image also.

    Thanks in advance.

  • Posted 22 November 2017, 8:11 am EST

    Hello,

    This is correct behavior , backgroundImage is not exported to excel. please read about the settings which are exported to Excel here:

    http://help.grapecity.com/spread/SpreadSheets10/webframe.html#excelexport.html

    Thanks,

    Deepak Sharma

  • Posted 23 November 2017, 12:55 am EST

    Hi Deepak,

    Thanks for your reply.

    Can you please tell me how can I export image also.

  • Posted 23 November 2017, 5:56 am EST

    Hello,

    Images as floating picture objects are exported to Excel with no issues. I checked it by inserting an image to this onlne demo and saved it as Excel.

    https://www.grapecity.com/en/demos/spread/JS/InspectorSample/

    The downloaded Excel file contains the picture object which I inserted.

    Please refer to the attached Excel file.

    Regards,

    Deepak Sharmaexport20171123152251.zip

  • Posted 23 November 2017, 8:20 am EST

    Hi Deepak,

    I used below code to add image :

    activeSheet.addPicture(“f2”,“Event.png”,2,2,6,6);

    var picture = activeSheet.findPicture(“f2”);

    Is this is the correct way to put floating picture objects?

    As, it is not getting exported.

  • Posted 27 November 2017, 10:55 am EST

    Hello,

    Please refer to the attached sample application. Run the sample with browser and insert an image by clicking the insert image button in toolbar. Then export it to Excel to see the image is exported to excel with no issues.

    Thanks,

    Deepak SharmaInspectorSample.zip

  • Posted 18 December 2017, 3:26 am EST

    Hi Deepak,

    My image is still not getting exported.

    I referred your code and put image in the same way, the image is appearing on the spread but not coming in exported file.

  • Posted 18 December 2017, 11:22 am EST

    Hi Deepali,

    Could you please provide me a sample application test this issue further? I am not able to replicate this issue using the sample application I provided to you in previous post.

    Thanks,

    Deepak Sharma

  • Posted 20 December 2017, 9:14 am EST

    Hi Deepak,

    I have attached sample code from my application.

    Please look into the issue and guide me.

    Project.zip

    Thanks,

    Deepali Gupta

  • Posted 26 December 2017, 8:33 am EST

    Hello,

    I have asked the development team to look into this issue. I will let you know as soon as I get any response. The tracking id for this issue is 252083

    Thanks,

    Deepak Sharma

  • Posted 27 December 2017, 6:06 am EST

    Hello,

    I missed on this, you would need to convert the image to base64 if the customer wants to export to excel.

    Please refer to the attached sample.

    Thanks,

    Deepak SharmaExportImageExcel.zip

  • Posted 28 December 2017, 2:35 am EST

    Hi Deepak,

    Thanks for your prompt response.

    Sorry but image is still not getting exported.I have used the exact code given by you.

    May be I am missing something.

    Please look into the issue as it is really urgent.

    Thanks

    Deepali Gupta

  • Posted 28 December 2017, 6:14 am EST

    Hi Deepali,

    Please refer to the attached video and sample application. It is working absolutely fine at my end.

    Thanks,

    Deepak SharmaSpreadJSExportimageToexcel.zipExportimageVideo.zip

  • Posted 28 December 2017, 7:17 am EST

    Hi Deepak,

    Its done now .

    Thank you so much for your help :slight_smile:

    Thanks,

    Deepali Gupta

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels