This project has moved. For the latest updates, please go here.

Number of rows in a worksheet

May 29, 2011 at 4:23 PM

I need to be able to iterate through a worksheet and determine the number of rows used. Since some of the rows can be blank, I can't just look for the first unused row. I don't see any kind of property about the number of rows (like a Rows.Count or RowCount in the Worksheet object). What is the best way without iterating to infinity?

Thanks in advance,

-Ron B.

Editor
May 29, 2011 at 4:29 PM

look at this thread http://epplus.codeplex.com/discussions/257072

May 29, 2011 at 4:30 PM

Thanks.