Sanskriti Tyagi (Sanskriti)
Accenture Solutions PvtLtd
Software Engineering Analyst
Accenture Solutions PvtLtd
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

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.