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.
Accepted Solution
Cognizant
IN
Hi Vikas,
Get it done by using binary file creation and calling GenerateMSOExcel OOTB activity approach.
Thanks,
Lakshmi
Pegasystems Inc.
IN
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
Cognizant
IN
Hi Vikas,
Thanks for replying.I am using 'pxResultsConvertCSV' OOTB activity and using parameters from 'LolRepeatsPage.pxResults' page,but the last 3 digits in 'MersMin' changing to zeros as mentioned in the attachment.
Thanks,
Lakshmi