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: 7 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.

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