Close popover
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

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