Question

2
Replies
673
Views
 Sanskriti Tyagi (Sanskriti)
Accenture Solutions PvtLtd
Software Engineering Analyst
Accenture Solutions PvtLtd
IN
Sanskriti Member since 2016 12 posts
Accenture Solutions PvtLtd
Posted: January 27, 2017
Last activity: January 30, 2017
Posted: 27 Jan 2017 4:54 EST
Last activity: 30 Jan 2017 8:11 EST
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.

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: 27 Jan 2017 8:08 EST
Jeff Badger (jeffbadger)
PEGA
Product Manager, Robotics
Pegasystems Inc.
US

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.