export xls with a image #642

New Issue

2017-04-24T09:49:47Z

oreillyj1 commented

2017-04-24 09:49:47 +00:00

(Migrated from github.com)

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

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 commented

2017-04-24 13:49:11 +00:00

(Migrated from github.com)

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

SheetJSDev commented

2017-04-24 15:37:56 +00:00

(Migrated from github.com)

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

Not currently. A partial implementation for XLSX image export was submitted as a [pull request](https://github.com/SheetJS/js-xlsx/pull/509/) but there are more details to work out.

oreillyj1 commented

2017-04-24 16:11:21 +00:00

(Migrated from github.com)

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

xSirrioNx commented

2017-05-17 12:38:47 +00:00

(Migrated from github.com)

@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 , 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 commented

2017-05-17 21:44:36 +00:00

(Migrated from github.com)

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?

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](url) like how do you add ` var data = "iVBORw0KGgoAA....` `ws["!images"] = [{...` into a existing sheetJs example ?...would you have capacity to outline?

xSirrioNx commented

2017-05-18 09:44:27 +00:00

(Migrated from github.com)

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

👍 1

oreillyj1 commented

2017-05-18 12:37:05 +00:00

(Migrated from github.com)

great thanks for that looks like a nice approach

HeroSony commented

2017-05-26 07:57:57 +00:00

(Migrated from github.com)

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

xSirrioNx commented

2017-05-26 12:51:04 +00:00

(Migrated from github.com)

@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! 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 commented

2017-05-29 02:05:26 +00:00

(Migrated from github.com)

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?

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 commented

2017-05-29 06:07:36 +00:00

(Migrated from github.com)

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

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

HeroSony commented

2017-05-29 06:23:54 +00:00

(Migrated from github.com)

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

@xSirrioNx , Greate.... Thank you very much... :+1:

Aymkdn commented

2017-05-29 06:37:59 +00:00

(Migrated from github.com)

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

bys-wallance-zhang commented

2017-07-25 08:34:23 +00:00

(Migrated from github.com)

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.

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 commented

2017-07-25 12:06:40 +00:00

(Migrated from github.com)

@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

@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 commented

2018-03-29 12:48:05 +00:00

(Migrated from github.com)

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

idr17 commented

2018-04-11 03:14:25 +00:00

(Migrated from github.com)

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

subrat7 commented

2018-04-13 12:30:26 +00:00

(Migrated from github.com)

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

hauteville86 commented

2018-04-16 11:21:42 +00:00

(Migrated from github.com)

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

SheetJSDev commented

2018-05-20 18:40:12 +00:00

(Migrated from github.com)

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.

We offer this in the [Pro compendium](https://sheetjs.com/pro). 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.](https://gist.github.com/SheetJSDev/24b8acd317d01999d721b38de7c53021)

sachinvar commented

2019-05-21 09:03:15 +00:00

(Migrated from github.com)

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

👍 7 👀 3

sachinvar commented

2019-05-21 09:05:06 +00:00

(Migrated from github.com)

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

nglpx1 commented

2020-04-23 07:58:59 +00:00

(Migrated from github.com)

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

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

balihoo-svarma commented

2020-04-23 08:31:27 +00:00

(Migrated from github.com)

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

No luck so far

> Hi, is it now possible export in xlsx an html table with an associated image? > Thanks. No luck so far

👎 1 😆 1

rifaldyaristya commented

2022-04-06 03:22:20 +00:00

(Migrated from github.com)

@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!

> @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!

Sign in to join this conversation.