Get Free Trial

How to add a sheet in exported excel

Shaharyar Mahmood asked on January 29, 2021

I am doing a pivot table export using flex monster. I want to add a sheet in the exported excel that will contain some details about the filters that user have selected in the UI.
Is there a way to add a sheet and provide data that will be added to it.

1 answer

Mykhailo Halaida Mykhailo Halaida Flexmonster February 1, 2021

Hi Shaharyar,
Thank you for posting your question.
Currently, Flexmonster does not provide built-in functionality to manipulate additional Excel sheets apart from the ones containing the exported data.
However, you could try the following: specify destinationType: "plain" in the parameters of exportTo() API call – once you do this, the grid content will be exported as a Uint8Array and returned with callbackHandler. After this, you can use a 3rd party library (SheetJS, for instance) to manipulate the received data and structure the resulting sheets in a way that suits you.
Please let us know if this helps.
Best regards,

Please login or Register to Submit Answer