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.
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.