How to disable the Flexmoster filters when exporting data to Excel.

posted on May 19th, 2023

Answered

Akshay Kamble asked on May 19, 2023

When exporting using exportTo, I am attempting to remove the report filter from the Excel sheet, which is visible in the attached image in the red highlighted box, but I am unable to do so with my current code. Please assist me in solving this issue.

Attachments:
flexmonster.png

3 answers

Public

Solomiia Andrusiv ⋅ Flexmonster ⋅ May 19, 2023

Hello, Akshay!

Thank you for contacting us.

As we understand, you want to hide the report filters details from the exported Excel file but remain the filter applied to the data. This can be done by using the showReportFiltersArea option, which hides the report filters' details from the UI while set to false.

So, we suggest the following approach to achieve the desired behavior:

Hide report filters area with mentioned option on exportstartevent.
Show report filters again on exportcomplete.

We have prepared a JSFiddle sample for visualization: https://jsfiddle.net/flexmonster/xf2epk7d/.
Please try exporting to Excep from the Toolbar to see the result.

Hope you will find our answer helpful.

Kind regards,
Solomiia

Public

Akshay Kamble ⋅ May 23, 2023

Hello Solomiia,
I appreciate you taking the time to respond so extensively. I'm really appreciative of it. The mentioned problem has been resolved.

I want to thank you again for your expertise and time.
Kind regards,
Akshay

Public

Solomiia Andrusiv ⋅ Flexmonster ⋅ May 24, 2023

Hello, Akshay!

Thank you for your feedback.

We are glad to hear that our approach works well for you.

Feel free to contact us in case of any other questions.

Regards,
Solomiia

How to disable the Flexmoster filters when exporting data to Excel.

3 answers

Please login or Register to Submit Answer