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

 Srinivas Sarda (SSrinivas)
Coforge
Srinivas Sarda
Coforge
IN
SSrinivas Member since 2015 65 posts
Coforge
Posted: May 2, 2018
Last activity: Jul 19, 2018
Posted: 2 May 2018 10:29 EDT
Last activity: 19 Jul 2018 15:41 EDT
Closed

Convert Excel sheet data to XML and viceversa

Hi Team,

We have a requirement where user will have Excel Sheet at certain path which we need to read and form a XML which will be request for web service and response XML what ever we get need to generate Excel in the same path.

Thanks

To see attachments, please log in.
Robotic Process Automation

Posted: 6 years ago
Posted: 2 May 2018 23:56 EDT
Raviteja Chatakondu (Raviteja_CH)
PEGA
Principal Technical Support Engineer
Pegasystems Inc.
US

Hi Srinivas,

We have OOTB utilities that parse the excel and generate pagelist from it and also that generates excel from a pagelist(MSOParseExcelFile and MSOGenerateExcelFile).

Assuming you have the connector in pega, You can use that page list that parse excel file generated as request in a connector and vice versa.

Please feel free to revert back incase you need any clarification.

-Ravi.

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