chrisb89123456789

How to modify the excel before export?

Dear all,

is there a way to modify the file from the excel export, e.g.
[*]transpose the maxtrix
[*]add another sheet with additional information

If that's possible, could anyone point me into the right direction?

Thanks,
Christopher
rafalS
Posts: 2665
Joined: Thu Jun 14, 2018 11:40 am

Re: How to modify the excel before export?

Hi Chris,

Thank you for contacting us again.

Are you saying about fetching the data from a spreadsheet, then parsing it and export the chart with additional information? Or you have normal data, but you want to export it to excel (.XLS)? Could you provide more info to make everything clear or (as always, this would be the best) create an online jsFiddle demo? It would solve all my doubts.

Best regards!
Rafal Sebestjanski,
Highcharts Team Lead
chrisb89123456789

Re: How to modify the excel before export?

Dear rafalS,

my chart is embedded in a widget container with a toolbar. Export is enabled and allows to export the chart data into an excel spreadsheet. Now I would like to add additional data to this exported spreadsheet (e.g. indicating some toolbar settings and so on).

To do this, I need to hook into the process of your excel export. How to do this?

Thanks,
Christopher
rafalS
Posts: 2665
Joined: Thu Jun 14, 2018 11:40 am

Re: How to modify the excel before export?

Christopher,

The method responsible for preparing data to export is Highcharts.Chart.prototype.getTable
Here is this method wrapped and ready for editing: https://jsfiddle.net/BlackLabel/9meL5tcs

https://www.highcharts.com/docs/extending-highcharts

Best regards!
Rafal Sebestjanski,
Highcharts Team Lead
ed1nh0
Posts: 4
Joined: Tue Jul 27, 2021 5:13 pm
Location: Brazil
Contact: Website

Re: How to modify the excel before export?

What about the second issue of the OP: [*]add another sheet with additional information.

I mean what about add another tab with additional info to the exported XLS file?
User avatar
sebastian.h
Posts: 1734
Joined: Fri Aug 07, 2020 7:08 am

Re: How to modify the excel before export?

Hi ed1nh0,

I think you should looking options to write to another sheet inside XLSX converter, directly from our API we don't support this feature.

https://jsfiddle.net/gh/get/library/pur ... data/xlsx/
https://api.highcharts.com/highcharts/exporting.csv

Best regards.
Sebastian Hajdus
Highcharts Developer

Return to “Highcharts Usage”