export xls with a image

[oreillyj1]

Hi does this library allow me to export a xls with a image somewhere on the sheet? if there are any jsfiddles on the web showing this it would also be great..
thanks

[oreillyj1]

hi Ive a query - does js-xlsx allow images to be exported to a xls file?

[SheetJSDev]

Not currently. A partial implementation for XLSX image export was submitted as a pull request but there are more details to work out.

[oreillyj1]

ok thanks, would there be a jsfiddle somewhere of the pull request do you know?

[xSirrioNx]

@oreillyj1 , i just make a fork, where try to implement styles and images from another forks to current version in main project (0.10.2)
https://github.com/xSirrioNx/js-xlsx

[oreillyj1]

hi xSirrioNx,
thanks for your help, im from a winform background [so apologies] but how would I take your folk and apply it into one of the sheetJs examples (ive copied to the jsfiddle) - https://plnkr.co/edit/OwwK00?p=preview

like how do you add
var data = "iVBORw0KGgoAA....
ws["!images"] = [{...
into a existing sheetJs example ?...would you have capacity to outline?

[xSirrioNx]

@oreillyj1, i make a JS fiddle how i use it in my project: https://jsfiddle.net/1g24vowu/1/

[oreillyj1]

great thanks for that looks like a nice approach

[HeroSony]

@xSirrioNx , your demo was great. Anyway do u know how can your code export with multiple sheets?

[xSirrioNx]

@HeroSony
Hi!
Thank you =) I just update xlsx.js in my fork and update fiddle: https://jsfiddle.net/1g24vowu/17/
Where are two sheets and two images on each.

[HeroSony]

Hi @xSirrioNx , Thank so much for your help and it really useful.

But now I've got another problem with rowspan and colspan. it's not working while export to excel.
Do you have any ideas?

[xSirrioNx]

@HeroSony , what's wrong?
Update Fiddle with merges: https://jsfiddle.net/1g24vowu/18/

[HeroSony]

@xSirrioNx , Greate.... Thank you very much... 👍

[Aymkdn]

@HeroSony I think you should open an issue on the fork of @xSirrioNx instead of using this thread....

[bys-wallance-zhang]

Hi @xSirrioNx,
I find a issue in https://jsfiddle.net/1g24vowu/1/, insert image can not work with add cell.l = {Target:""}, the export xlsx will remove image.

[bys-wallance-zhang]

@xSirrioNx,
Hi xSirrioNx,，I find 2 issues, one is the image only be inserted 1st sheet, if add the 2nd the image not be present in export file;
another issue is when heperlink and image add the same sheet, the image will be removed from the export file

[nikolasrangel]

Hi @xSirrioNx, can you reupload into jsfiddle your code that create a sheet with images? Thanks

[idr17]

yes @xSirrioNx , I would be very grateful if u reupload into jsfiddle.

[subrat7]

Can anyone send the snippet for this features ,the link provided above isn't working ,please provide the working link.

[hauteville86]

I second to that. It would be great to receive some tip on how to insert an image into our generated XLSX file.

[SheetJSDev]

We offer this in the Pro compendium. Since companies have paid for the features already, it would be unfair to them if we turned around and made it available as open source. We have a longer comment in a gist.

[sachinvar]

is there any plan to make it available as open source?

[sachinvar]

Is there any other react node modules, which is providing support for exporting image in generated excel?

[nglpx1]

Hi, is it now possible export in xlsx an html table with an associated image?
Thanks.

[balihoo-svarma]

Hi, is it now possible export in xlsx an html table with an associated image?
Thanks.

No luck so far

[rifaldyaristya]

@HeroSony Hi! Thank you =) I just update xlsx.js in my fork and update fiddle: https://jsfiddle.net/1g24vowu/17/ Where are two sheets and two images on each.

Hey can you reopen this? This link doesn't exist anymore @xSirrioNx . Thanks in advance!

[ka11den]

@HeroSony Hi! Thank you =) I just update xlsx.js in my fork and update fiddle: https://jsfiddle.net/1g24vowu/17/ Where are two sheets and two images on each.

Hey can you reopen this? This link doesn't exist anymore @xSirrioNx . Thanks in advance!

fill it up again please