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

Jan 11, 2011 at 3:43 PM

Hi,

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)

 

Thanks

Srikanth Kambhampati

Coordinator
Jan 11, 2011 at 5:52 PM

Hi

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,

Jan