Question

Repeat grid results exporting to Excel

Hello ,

I have requirement to export the results of a repeating grid . grid is defined with source as page list. I have tried using OOTB rule pxConvertResultsToCSV and exportToExcel .

I am calling above activities on click of button .Both are working fine for the 1st time and able to see the excel with results. If I click the button next time then its not downloading any excel.

Thanks

Correct Answer
February 22, 2019 - 12:11pm

Hi Vijay,

I tried a sample use case in Pega 7.4 and attached for your reference which is exporting the data page list content correctly on each click. Kindly try this approach and let me know if you still need help on this requirement.

Regards,

Mahesh M

Comments

Keep up to date on this post and subscribe to comments

February 22, 2019 - 12:11pm

Hi Vijay,

I tried a sample use case in Pega 7.4 and attached for your reference which is exporting the data page list content correctly on each click. Kindly try this approach and let me know if you still need help on this requirement.

Regards,

Mahesh M

February 22, 2019 - 12:25pm
Response to Mahesh Midthuru

Thanks Mahesh. it worked . I didn't select 'use page' option.

February 22, 2019 - 1:56pm
Response to VIJAY1219

That's the tricky part in your requirement.

February 28, 2019 - 9:51am

Hi Mahesh,

once system export the data into the excel sheet all numbers are converting like 4.44E+11 instead of 444444000000

excel sheet format cells category taken as General by default

I have tried with pxConvertResultsToCSV activity  Parameter: CSVPropertyTypes  with Interger  as well but still issue not resolved

Could you please suggest me correct path?

March 5, 2019 - 10:39am
Response to Ravindra

Hi Ravindra,

By default the column value will be displayed as 4.44E+11 instead of 444444000000, if you drag the column header in order to display the full number then it will be displayed completely. Hope that clarifies your doubt.

Regards,

Mahesh M

October 18, 2019 - 4:46pm
Response to Mahesh Midthuru

I have a similar problem wherein i need to display decimal values in currency formay with a dollar sign: example- $2000.00

If there a way to export page list to CSV or excel but also maintain a certain format in excel sheet. 

Please note that providing property type does not help.