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.
⋅ 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,
Mykhailo
