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

 Shivanshu Kapoor (ShivanshuK)
Accenture
IN
ShivanshuK Member since 2016 24 posts
Posted: Feb 13, 2017
Last activity: Feb 28, 2017
Posted: 13 Feb 2017 6:51 EST
Last activity: 28 Feb 2017 0:14 EST
Closed
Solved

Reading Data from an Excel Sheet

Hi , I would like to know whether its possible to read all the data (rows & columns) from an excel sheet till the end of the last non empty row when the number of rows and columns in the sheet are not known ?

Any leads will be appreciated. Thanks!

***Updated by moderator: Lochan to add Categories***

To see attachments, please log in.
Robotic Process Automation

Posted: 8 years ago
Posted: 13 Feb 2017 7:26 EST
Mukesh agrawal (Mukesha0)
Cognizant Technology Solutions India PVT Ltd

Cognizant Technology Solutions India PVT Ltd
IN

 OOTB activity:@baseclass.MSOParseExcelFile is useful for your requirement. It has a Java step where the whole logic is written in it.

To see attachments, please log in.

Related content:

Related content has not currently been identified for this post.

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