Get Free Trial

How to add a sheet in exported excel

Answered
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

Public
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,
Mykhailo

Please login or Register to Submit Answer