Last activity: 14 Nov 2018 23:54 EST
Create and export data in excel format with multiple excel tabs created dynamically
I have a requirement to create and download the data from clipboard in Excel format. Until now I was using MSOParseExcelFile for mapping the data from clipboard to excel template. However now my new requirement is to create the tabs in excel sheet dynamically based on a pagelist. So for example if my pagelist "TestList" contains 2 records in it while user clicks on the Export button, the program should create 2 tabs in excel sheet and map the corresponding data in those sheet and initiate the download.
Is there any OOTB way of handling the same? If not how best can i handle it?
Thanks for the help.
***Edited by Moderator: Pallavi to update platform capability tags***