HTML data with image export into Excel ! Please any help

JavaScript
1

I have used google charts where i can generate chart .i can generate an image as per google chart doc. i want that image export into excel. how can i do this i tried some Jquery plugin but not success image was broken. any free library which used my code. or javascript code

I want html table data store on sheet no.1 and that image stored on sheet no.2 how can i do

<img src= "data:image/png;base64, 4d564asd46asdasdasdasd698asd9s8ad798as7d87sd...">

I want this image export into excel. Please suggest some solutions.

2

You need to convert the base64 string to an image, and afaik you will have to do that server-side. If that’s not possible, then you need the image in a format excel understands to start with (png for example in this case?)

3

well,Please help me how can that image convert into excel understands. I Trying lot of but didn’t get any solution

4

try this code may be help you

$("[id$=myButtonControlID]").click(function(e) { window.open('data:application/vnd.ms-excel,' + encodeURIComponent( $('div[id$=divTableDataHolder]').html())); e.preventDefault(); });

5

Thanks, i have tried that code but not export image.

1 Like
6

I don’t know exctly what you’re doing or how you’re doing it at the minute, so I can’t give any specifics, but what you have is a binary representation of an image: a browser can decode it to an image, but it isn’t the same as an image file.

To convert it to an image, you have to do it server-side (ie you need a program running on a computer that you can talk to over HTTP that can convert the base64 string to an image file, then store the image file so you can access it). You cannot do it in just in the browser. If you cannot write a server-side application, you can use a service like Cloudinary, which allows you to upload base64 encoded images, and will then allow you to pull down the resulting image file - https://support.cloudinary.com/hc/en-us/articles/203125741-Can-I-upload-using-DATA-URI-BASE64-