Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Rosy Salame (RosyS608) Salame
Salame
RosyS608 Member since 2015 71 posts
Salame
Posted: Mar 2, 2016
Last activity: Mar 2, 2016
Posted: 2 Mar 2016 9:10 EST
Last activity: 2 Mar 2016 10:23 EST
Closed
Solved

Export/Import to Excel

Report

Hello Guys,

I have the following matrix inside Pega:

ScreenHunter_131 Mar. 02 16.08.jpg

I need to export this matrix to Excel, then, modify some cells values and import it back to Pega. Is it possible to do that?

Thanks,

Rosy

Message was edited by: Lochan to add Category

User Experience

Accepted Solution

Posted: 7 years ago
Posted: 2 Mar 2016 9:34 EST
Santanu Bhattacherjee (Santanu) Senior Manager, Cloud Engineering, Management Plane Services
Pegasystems Inc.
IN
Report

Hi

How you are showing this matrix ? Is it via grid or some customized HTML ?

Anyway,exporting the content to excel and then editing it and upload it back to PEGA is doable in PRPC.

Refer this Flow action as reference : PegaAccel-Task-ImportExport-Requirements • pzUploadRequirementsExcel Pega-AppDefinition:07-10-01  which is calling pzExcelValidateAndUploadRequirement activity as post action and in this activity step 9 we are having a call to MSOParseExcelFile activity which is validating and uploading the excel.

Also please see this articles :

https://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm
Posted: 7 years ago
Posted: 2 Mar 2016 9:50 EST
Rosy Salame (RosyS608) Salame
Salame
Report

Thanks a lot Santanu for your answer! I will check that and get back to you.

Concerning your question, I\m showing the matrix using a grid containing another column repeat.

Regards,

Rosy

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice