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

Load rows containing data

Oct 13, 2011 at 3:48 PM


How can i determine the number of rows actually containing data in a worksheet loaded from the file. 

My problem i when I load a worksheet i get rowcount=1048576 that is true that is the upper limit but in my case im just interested in reading the rows that contain values. 

Is there a way to determine the used range ?


Best regards Anders

Oct 13, 2011 at 7:01 PM

In your case you'll probably be okay with other of the following:



I could have sworn there was a worksheet.RowsUsed() method. I'll add it then.