You can work with the rows and columns of the sheet and distinguish which ones have data by using various members of the SheetView class. You can use the following methods available on the sheet.
- GetLastNonEmptyColumn method
- GetLastNonEmptyRow method
You can get the number of rows and columns that have data using these properties:
- NonEmptyColumnCount property
- NonEmptyColumnCount property