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... 👍