Finding Rows or Columns That Have Data

Spread Windows Forms 10.0 Product Documentation

Collapse All

Spread Windows Forms 10.0 Product Documentation > Developer's Guide > Customizing Row, Column, and Cell Appearance > Customizing the Row or Column Appearance > Finding Rows or Columns That Have Data

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 return the number of rows and columns that have data using these properties:

NonEmptyColumnCount property
NonEmptyColumnCount property

Support Options | Documentation Feedback