Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

Set customFields for Excel export

Answered
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

Public
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,
Illia

Public
Richard November 28, 2019

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

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster January 28, 2020

Hello,
 
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,
Illia

Please login or Register to Submit Answer