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

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

To see attachments, please log in.
User Experience

Accepted Solution

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

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

To see attachments, please log in.
Posted: 8 years ago
Posted: 2 Mar 2016 9:50 EST
Rosy Salame (RosyS608)
Salame

Salame

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

To see attachments, please log in.

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