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
Wells Fargo
IN
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.
Pegasystems Inc.
IN
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
Pegasystems Inc.
GB
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 ?
Pegasystems Inc.
IN
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
Wells Fargo
IN
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.
Randstad Technologies US
US
Instead of writing html code ,we can use OOTB activity pxConvertResultsToCSV which exports pagelist and convert into csv(you can open it using excel).
Wells Fargo
IN
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.