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

 Regulagedda Pavani (RegulageddaPavani)
United health group

United health group
IN
RegulageddaPavani Member since 2015 35 posts
United health group
Posted: Apr 7, 2016
Last activity: Apr 7, 2016
Posted: 7 Apr 2016 1:19 EDT
Last activity: 7 Apr 2016 1:37 EDT
Closed

How to read data from multiple tabs in excel sheet

Hi All,

I have a requirement to read data from multiple tabs in excel sheet , please suggest how to achieve it.

To see attachments, please log in.
Data Integration

Posted: 8 years ago
Posted: 7 Apr 2016 1:33 EDT
Ravi Kumar Pisupati (Mr. Ravi Kumar Pisupati)
GovCIO
Pega Lead Solutions Architect
GovCIO
US

Hello Pavani,

I think OOTB activity:@baseclass.MSOParseExcelFile is useful for your requirement. It has a Java step where the whole logic is written in it. Basically this activity is used while importing the Requirements/Usecases using AP wizard in V62 and I hope the same is used in V7 too. Study this activity and the way of calling from the referencing rules. You will get an idea on how to achieve your requirement.

Thanks,

Ravi Kumar.

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