Excel range limits
-
I'm reading an Offic 2000 Excel spreadsheet through a c# app and I would like to know the limits of the populated cells, rather than itterating through until I read an empty cell (this is not a good mathod because a sheet can have gaps in it) Is there a method that will return a single range covering the populated cells?
-
I'm reading an Offic 2000 Excel spreadsheet through a c# app and I would like to know the limits of the populated cells, rather than itterating through until I read an empty cell (this is not a good mathod because a sheet can have gaps in it) Is there a method that will return a single range covering the populated cells?
To answer my own question: WorkSheet.UsedRange; but this range includes cells have formatting, but may be empty.