Posted: 14 Feb 2017 0:12 EST Last activity: 27 Jul 2017 11:30 EDT
Reading Data from an Excel Sheet In Pega Robotics Studio 8
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***
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.