Question

3
Replies
5400
Views
Close popover
Shivanshu Kapoor (ShivanshuK)
Accenture

Accenture
IN
View Profile
ShivanshuK Member since 2016 24 posts
Accenture
Posted: February 13, 2017
Last activity: February 28, 2017
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
Close popover
Moderation Team has archived post
Posted: 3 years ago
Close popover
Mukesh Agrawal (MukeshAgr)
Virtusa

Virtusa
IN
View Profile

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

Posted: 3 years ago
Close popover
Shivanshu Kapoor (ShivanshuK)
Accenture

Accenture
IN
View Profile

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 !
Share this page Share via LinkedIn Copying...
Copied!