How to write excel file with chart using js-xlsx

Question

Using SheetJS js-xlsx "xlsx": "0.15.1" js is there a way to write excel file with chart.

Basically I want to export html page that contains chart into an excel file.

HTML page is getting exported successfully but the chart in the page is not getting displayed.

Here is the code I have used

let wb =XLSX.utils.book_new();

 let element: any = document.getElementById('page1');
 let ws = XLSX.utils.table_to_sheet(element);
 XLSX.utils.book_append_sheet(wb,ws,'page1');

what charting library are you using to draw chart in html ?

Tarun Khosla
– Tarun Khosla

2019-09-09 15:25:38 +00:00
Commented Sep 9, 2019 at 15:25 — Tarun Khosla
– Tarun Khosla, Commented Sep 9, 2019 at 15:25
Provide a sample of element.

hoangdv
– hoangdv

2019-09-10 03:26:33 +00:00
Commented Sep 10, 2019 at 3:26 — hoangdv
– hoangdv, Commented Sep 10, 2019 at 3:26

dav1app · Accepted Answer · 2019-09-15 22:34:58Z

1

Are you using the Community build or the Pro?

As stated here, The Community build reflects the data cached in charts as worksheets. Other chart-related features, including writing and reading metadata, are included in the Pro compendium.

Remember to include your work as Chartsheet, just in case. It will continue to render it as a Worksheet if you are using the community version, but it will help us to understand the desired behavior that you are seeking.

If you provide more reference for the code, maybe we can show you some shortcuts to make it work.

answered Sep 15, 2019 at 22:34

dav1app

2,1911 gold badge10 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to write excel file with chart using js-xlsx

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related