Question
2
Replies
637
Views
Posted: January 27, 2017
Last activity: January 30, 2017
Closed
To read all the non-empty rows in an Excel Sheet
Hello Folks,
I am trying to read the data from an excel sheet and put in a windows form in table view. While reading the data, I need to know any method where I don't have to give the end cell value manually, i.e. it should be able to reach the end of non-empty rows by itself. Also I want to know how to read all the columns for all the rows. I am attaching the file I am trying to read and export the data as it is in Windows Form DATA GRID.
Any leads would be highly appreciated.
Posted: 3 years ago
Check out my Excel How To post. It give the details on how to build automations to determine this.
https://pdn.pega.com/community/product-support/question/pega-robotics-excel-how
A worksheet has a property named UsedRange. This will show you the boundaries of the data. You will need to get the worksheet first and then extract a proxy to access the UsedRange. I am going to add a post today that will show how to get a worksheet by name and then how to get the used range. Look for those posts.