Question

how to parse Excel spreadsheet and put data in Excel on clipboard

I know there are out of box activities that do this because it had been done in the project that I was in about six years back.

But I forget the details. Maybe it even involves parsing a template, which maps field in Excel to properties.

Can someone give me directions and/or let me know the activity name?

Thanks in advance.

***Edited by Moderator Marissa to update platform capability tags****

Comments

Keep up to date on this post and subscribe to comments

June 24, 2019 - 8:31pm

Please check out this link.

https://community1.pega.com/community/pega-support/question/apache-poi-%E2%80%93-parsing-excel-workbook

You could also make use of pxParseExcelFile API, which might be the activity you remember..

Pega
June 24, 2019 - 9:29pm

Hi Yining,

Please check my comment in below post for detailed configuration using MSOParseExcelFile activity.

https://community1.pega.com/community/product-support/question/how-parse-and-excel-or-csv-file

You can use pxParseExcelFile activity instead in latest versions as 'MSOParseExcelFile' activity is deprecated.

Thanks.