Question
how to export data to excel using RDB list method
Hello Team,
I am connecting to Cloud SQL database and getting data using RDB list method and able to get results on clipboard i.e LolRepeatsPage.pxResults and same reference i have used to show data on Repeating grid shown in the attached document.
I have an requirement to show the data and export the same in excel format. Since i am not storing the results in local pega database what is the best way to export the data in excel format.?
i have used 'pxConvertResultsToCSV' OOTB activity and able to export the data in the csv format but the last 3 digits chaging to zeros.
Please refer the attached file for more details and kindly let me know if any other OOTB activity can be used?
Thanks.
Hi Lakshmi,
There are 2 approaches that you can try:
1. Use pxResultsConvertCSV activity and make use of LolRepeatsPage.pxResults which is available on the clipboard.
2. Use MSOGenerateExcelFile OOTB activity instead of pxResultsConvertCSV activity and add the Excel Template and pass the parameter.
Please try one of the above approach and let me know if it works fine.
Regards,
Vikash