How to generate excel file in a specific format
We can generate an excel by using the "MSOGenerateExcelFile" for the only one-page list, but i have a header and 2-page lists are available in the excel template.
let me know what is the best way to generate the excel as per the screenshot.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Accepted Solution
Posted: 3 years ago
Posted: 3 years ago
Yes I have already tried with the "MSOGenerateExcelFile" but no luck. I need to go with the custom java code only.
Hello ,
Can you give it a try , add in template pyWorkpage.PageList1 , pyWorkPage.PageList2 and use pyWorkpage as steppage "MSOGenerateExcelFile" to get the desired excel.
Or write custom java code to achieve same.
https://pdn.pega.com/community/product-support/question/need-generate-excel-file-report-definition-and-save-shared