Question
Cognizant Technology Solutions Pvt Ltd
US
Last activity: 16 Oct 2018 12:03 EDT
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
Pegasystems Inc.
IN
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.
Cognizant Technology Solutions Pvt Ltd
US
Yes I have already tried with the "MSOGenerateExcelFile" but no luck. I need to go with the custom java code only.