Question

3
Replies
5566
Views
 Shivanshu Kapoor (ShivanshuK)
Accenture

Accenture
IN
ShivanshuK Member since 2016 24 posts
Accenture
Posted: February 13, 2017
Last activity: February 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***

Robotic Process Automation
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
Posted: 13 Feb 2017 7:26 EST
Mukesh Agrawal (MukeshAgr)
Virtusa

Virtusa
IN

 OOTB activity:@baseclass.MSOParseExcelFile is useful for your requirement. It has a Java step where the whole logic is written in it.
Posted: 4 years ago
Posted: 14 Feb 2017 0:51 EST
Shivanshu Kapoor (ShivanshuK)
Accenture

Accenture
IN

Hi Mukesh,


I forgot to mention that I need to read data in Pega Robotics Studio and not Pega PRPC.  Anyway,


Thanks a lot for the reply !