Need export to excel feature for a page list with structure
Even i have a page list with structure mentioned above and need export to excel feature.
Accepted Solution
Resolved the issue by building HTML with TD/TR tags giving page list as reference.
Both solutions above will work only for a simple page list.
Since my structure is page list within a page list within a page list, built HTML as mentioned above.
Then usual , property-set-stream and show-property. Refer ViewExcelData for reference code.
Hi,
I hope below PDN links will be useful for your case, which has step by step approach to acheive this .
https://collaborate.pega.com/discussion/export-excel-grid-report-definition-source
https://collaborate.pega.com/question/export-excel-feature-grid-layout
Thanks & Regards,
Durga
How do you plan to organise your output Excel - which is un-nested rectangular data - to fit a tree - which is nested , hierarchical data ?
Have you tried created a manual represention of what you want your Excel file to look like ?
I could be wrong here - but I'm not sure there will be an 'off-the-shelf' Activity you can use here - because you will need to make some decisions about how to map the data from one structure to another ?
Hello,
You can use MSOGenerateExcelFile activity with pagelist as the steppage.
https://collaborate.pega.com/question/how-msogenerateexcelfile-works-719
OR
Below thread explaining result to csv export.
https://collaborate.pega.com/question/how-export-pagelist-clipboard-tool-excelcsv
Accepted Solution
Resolved the issue by building HTML with TD/TR tags giving page list as reference.
Both solutions above will work only for a simple page list.
Since my structure is page list within a page list within a page list, built HTML as mentioned above.
Then usual , property-set-stream and show-property. Refer ViewExcelData for reference code.
pxConvertResultsToCSV will work if the page list structure is a simple one, say ReportPage.pxResults()
In my case, structure is like ReportPage.pxResults(1).pxResults()
ReportPage.pxResults(2).pxResults()....so on.
This structure did not work with "pxConvertResultsToCSV" activity. Also, i had a footer to my excel which was possible only thru HTML code.