That count could be (and probably will be) inaccurate. It indicates the number of rows or columns which have been lazy loaded. A row could be accessed and have nothing changed on it. Just getting a row instance will force it to be created, and that will increment the count of the collection. Or a row can have something changed on it, then the change can be reset, and the count will still include that row.

Fair enough, it worked for my small test 2x2 spreadsheet - guess I was just lucky...

I'm really keen to not have to create 16 million WorksheetCell objects, and iterate over 16 million cells in order to get the few cells that have values... But fortunately there is a solution.

Cheers,

After loading the rows and columns collection will have entries for all rows and columns that has data. However we can just look at the index property to determine the row and column positions. To get the number of rows and columns look at the index of the last entry.

And in my example I have omitted the check whether the Rows and Columns collections are in fact empty...

Thanks, but it can be tricky due to possibly very large file dimensions. If only it was calculated at runtime...

Will try to find a solution :)

You can just loop over a row's Cells collection with a foreach loop. This will give you all cells which have a value or a non-default cell format.

Yes, you're right with a columns, but there is a property for WorksheetRow named "HasCellBlocks", which also isn't accessible.

My problem is when cell is empty but, for example, resized. Then it exists in the Cells collection, but it's Value is null. These cells are often at the bounds, and what I need is to know when I find an empty row: this row is empty at the middle of data (count as error) or it is "end of the document". A property like "HasCellBlocks" could easily tell me if the row have any values.

This property is only initialized and used when saving a file, so it would not be useful at run-time. Also, it just indicates whether the column has a non-default width or a non-default cell format, so I don't think it would help you that much. What are you trying to do with the columns?

I just wonder why column's property "HasData" was made private :(