🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

Set customFields for Excel export

Richard asked on November 28, 2019

I know I can set the customFields property when initializing Flexmonster or at a later moment through the getReport and setReport methods. Unfortunately, when using setReport, the grid refreshes, which is unnecessary when just adding customFields for the excel export. 

Is there any other way to set customFields after initializing the report?

I’m thinking a setCustomFields() method would be convenient or possibly adding customFields to the params object of the exportTo() method.

3 answers

Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 28, 2019

Hello, Richard,
Thank you for reaching out to us.
Adding the ability to apply custom fields through the exportTo method sounds reasonable. Our team has added it to our backlog.
We would like to kindly ask you about how critical is the feature for your evaluation?
You are welcome to contact us in case of any additional questions appear.
Best Regards,

Richard November 28, 2019

Thank you!
This feature is not critical, but would be nice to have. 
Best Regards,

Illia Yatsyshyn Illia Yatsyshyn Flexmonster January 28, 2020

We are glad to inform you that headers and footers are added for Excel export.
Headers and footers can be defined as a parameter of the exportTo method.
Now exports are consistent and can be applied through “headers” and “footers” export options properties.
The structure has to be similar to the following:

flexmonster.exportTo("excel", { header: "Custom header" });

For CSV and Excel, there is an option to apply mutly-rows headers adding the headers/footers the following way “Row1\nRow2\nRow3”.
Please check out an example we have prepared for you.
This is provided in the 2.7.24 version of Flexmonster: https://www.flexmonster.com/release-notes/
You are welcome to update the component.
Here is our updating to the latest version guide for assistance: https://www.flexmonster.com/doc/updating-to-the-latest-version/ 
Please contact us in case any questions arise.
Best regards,

Please login or Register to Submit Answer