This project has moved and is read-only. For the latest updates, please go here.

How to know the number of rows to read from the excel?

Jan 11, 2011 at 3:43 PM


Is there a way to know how many excel rows have been modified to read from the excel? (same with the columns)?

How to iterate through the rows in the excel work sheet? (same with columns)



Srikanth Kambhampati

Jan 11, 2011 at 5:52 PM


Use the Worksheet.Dimensions property to get the First and Last cell.

If you have a lot of blank cells check out the Linq sample (sample8) to get only created cells,