Closed
Generating multiple excel tabs dynamically
Hello All,
I have a requirement to generate the Excel tabs dynamically with data. I do have a template in 1st tab for 1 state. So if i select 5 different states, The same template should appear in 5 different tabs along with data. We cannot hardcode the template because it will automatically add an empty tab if we do that. Can anyone help on how to implement this requirement?
Thanks in Advance
***Edited by Moderator Marissa to change type from Pega Academy to Product***
To see attachments, please log in.
Posted: 2 years ago
Infomatics Corp
Infomatics Corp
US
Hi Praveen i dont think so there is any Utility to create dynamic sheets in the Excel based on the data. You can use apache poi library by writing the custom code in a function to achieve your requirement.
Or other way is to generate multiple excel files based on your template and then you can combine them into one workbook using the apache Poi.