Question
Accenture
IN
Last activity: 27 Jul 2017 11:30 EDT
Reading Data from an Excel Sheet In Pega Robotics Studio 8
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 in Pega Robotics Studio 8?
Any leads will be appreciated. Thanks!
***Updated by moderator: Lochan to add Categories***
Accepted Solution
Pegasystems Inc.
US
I have attached an example by Jeff Badger that shows you how to get the used range. The automation is attached as a text file, so rename the extension .os to import it into your solution. The screenshot shows how you would call it. Basically;
- Extract a proxy from the Excel Connector's ExcelWorkBook property.
- Pass the ActiveSheet property of proxy object into the worksheet property of the automation.
Keep in-mind that this may include blank rows, so you might need to use C# to filter those out as Excel counts any cell that has ever been used as part of the range. You can get an idea of the range in a worksheet by clicking Ctrl+End which will take you to the last cell in the worksheet.
Capgemini
IN
Hi Shivanshu,There is a method getellvalue once there is a value in the result you need to add the logic to proceed the next cell or you need to break the for loop.
Accepted Solution
Pegasystems Inc.
US
I have attached an example by Jeff Badger that shows you how to get the used range. The automation is attached as a text file, so rename the extension .os to import it into your solution. The screenshot shows how you would call it. Basically;
- Extract a proxy from the Excel Connector's ExcelWorkBook property.
- Pass the ActiveSheet property of proxy object into the worksheet property of the automation.
Keep in-mind that this may include blank rows, so you might need to use C# to filter those out as Excel counts any cell that has ever been used as part of the range. You can get an idea of the range in a worksheet by clicking Ctrl+End which will take you to the last cell in the worksheet.
Pegasystems Inc.
US
You can also look at my post
https://collaborate.pega.com/discussion/pega-robotics-excel-how
for instructions on building this and other automations in Excel.