Get Free Trial

Exported data missing header data from the gid

Matt Davis asked on April 23, 2018

We are continuing our evaluation to replace FlexMonster with the current silverlight implementation.
In exporting the data from the grid to an excel spreedsheet we have noticed a discrepancy with the output and what is in the export. There is no summary of filters and data points are missing
Is there a way to include what we want with the exported data (see attached screen shots)?

3 answers

Dmytro Zvazhii Dmytro Zvazhii Flexmonster April 24, 2018

Hello Matt, 
Thank you for your question. Please find the information about extending exporting functionality here: You need to set showFilters property true so the pivot can export the filters to Excel. Here is the example:
Please let us know if the issue is resolved.

Matt Davis April 24, 2018

Hi Dmytro,
Thanks. I can see how that should work. Is there a prescribed way to add that into the existing export excel button provided by the tool bar?

Tanya Gryshko Tanya Gryshko Flexmonster April 25, 2018

Hello, Matt,
Thanks for your quick feedback! We are happy that the suggested approach works for you.
Our recommended way to customize Toolbar functionality is to use beforetoolbarcreated event. For more details please refer to Customizing toolbar tutorial.
Please inform me in case of further questions.

Please login or Register to Submit Answer