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***
2. Use the Apache POI library directly from PRPC to programmatically generated (binary, xlsx) Excel files.
I have attached a ZIP file containing a couple of old posts I put together a few years ago: the following direct links to these posts may still work for you (but don't rely on them, since they are not guaranteed to remain available):