asked on August 17, 2023
We are working on a project that works using a web application to display some pivot tables using Flexmonster. As there is the option to export as an Excel, we want to modify the export setting so that the exported Excel file contains a general footer, as of date, and list of filters being applied in the Flexmonster. Where can we make these changes (in the JS or TS project files)?
Work environment: VS Code, JavaScipt, Typescript
⋅ August 17, 2023
Hello, Shahid!
Thank you for reaching out to us.
Kindly note that you can customize the footer while exporting to Excel by adding a string as the footer parameter of exportTo() API call. It is possible to customize our existing Toolbar tab as well as create your control and use exportTo() on click.
You can also show members' filters along with the report filters in the header of the exported Excel by enabling the showFilters parameter in the exportTo().
You can find more details about exporting to Excel in our documentation: https://www.flexmonster.com/doc/export-report/#excel.
We have prepared an example with the customized footer and enabled filters in header modifying the default Toolbar tab: https://jsfiddle.net/flexmonster/mu52zdqa/.
Please let us know if the described approach works for your case.
Kind regards,
Solomiia
⋅ September 6, 2023
Hello, Shahid!
Hope you are having a great week.
Just checking in to ask if the suggested approach was helpful in customizing export headers.
Looking forward to hearing your feedback.
Kind regards,
Solomiia
