For a list of all members of this type, see Worksheet members.
Public Properties
| Name | Description | |
|---|---|---|
 | ActiveCell | Gets the active cell in the sheet. |
| ActiveColumn | Gets the active column in the sheet. |
| ActiveColumnIndex | Gets or sets the column index of the active cell in the sheet. |
| ActiveRow | Gets the active row in the sheet. |
| ActiveRowIndex | Gets or sets the row index of the active cell in the sheet. |
| AutoGenerateColumns | Gets or sets whether to automatically generate the columns for a sheet based on the data source. |
| CalcManager | |
| Cells | Gets the two-dimensional collection of Cell objects. |
| Charts | Gets the charts. |
| ColumnCount | Gets or sets the number of columns in the sheet. |
| ColumnHeader | Gets the column header area of the sheet. |
| ColumnHeaderSpanModel | Gets the column header span model. |
| ColumnRangeGroup | Gets the column range group. |
| Columns | Gets the one-dimensional collection of Column objects. |
| ConditionalFormats | Gets the conditional format for the sheet. |
| CustomFunctions | Gets the name of all custom functions. |
| CustomNames | Gets all custom names. |
| DataAutoHeadings | Gets or sets whether to automatically generate column names for a sheet based on the data source. |
| DataSource | Gets or sets the data source that populates the sheet. |
| DefaultColumnWidth | Gets or sets the default column width. |
| DefaultRowHeight | Gets or sets the default row height. |
| DefaultStyle | Gets or sets default style information for the workbook. |
| FloatingObjects | Gets the floating objects. |
| FrozenColumnCount | Gets or sets the number of nonscrolling columns on the leading edge of this sheet. |
| FrozenRowCount | Gets or sets the number of nonscrolling rows on the leading edge of this sheet. |
| FrozenTrailingColumnCount | Gets or sets the number of nonscrolling columns on the trailing edge of this sheet. |
| FrozenTrailingRowCount | Gets or sets the number of nonscrolling rows on the trailing edge of this sheet. |
| GridLineColor | Gets or sets the gridline color. |
| Item | Overloaded. Gets a new cell with a specified tag, or returns null if there is no cell with the specified tag. |
| LastNonEmptyRowIndex | Gets the last nonempty bound row index on the sheet. |
| Name | Gets or sets the name of the sheet. |
| NamedStyles | Gets or sets a collection of StyleInfo objects for this sheet. |
| NonEmptyRowCount | Gets the number of rows in cell blocks that contain data, styles, tags, or sparklines. |
| Pictures | Gets the pictures. |
| PrintInfo | Gets or sets the print information for printing to PDF. |
| Protect | Gets or sets whether cells on this sheet that are marked as protected are uneditable. |
| ReferenceStyle | Gets or sets the style for cell and range references in cell formulas on this sheet. |
| RowCount | Gets or sets the number of rows in the sheet. |
| RowFilter | Gets or sets the row filter for the sheet. |
| RowHeader | Gets the row header area of the sheet. |
| RowHeaderSpanModel | Gets the row header span model. |
| RowRangeGroup | Gets the row range group. |
| Rows | Gets the one-dimensional collection of Row objects. |
| SelectionBackground | Gets or sets a Brush object for the selection style. |
| SelectionBorderColor | Gets or sets a Color object for the selection style. |
| SelectionBorderThemeColor | Gets or sets a string object for the selection style. |
| SelectionPolicy | Gets or sets whether users can select ranges of items. |
| Selections | Returns a collection of selected cell ranges. |
| SelectionUnit | Gets or sets whether users can select cells, rows, or columns. |
| SheetTabColor | A color object used to represent the sheet tab color. |
| SheetTabThemeColor | A theme color used to represent the sheet tab color. |
| ShowGridLine | Determines whether to show gridlines. |
| SpanModel | Gets the sheet span model. |
| StartingColumnNumber | Gets or sets the number or letter displayed in the first column header in this sheet. |
| StartingRowNumber | Gets or sets the number or letter displayed in the first row header in this sheet. |
| Tag | Gets or sets the tag. |
| TouchSelectionGripperBackgroundColor | Gets or sets a Color object for the selection style. |
| TouchSelectionGripperBackgroundThemeColor | Gets or sets a string object for the selection style. |
| Visible | Gets or sets a value that indicates whether to display the sheet. |
| Workbook | Gets the parent workbook for this sheet. |
| ZoomFactor | Gets or sets the scaling factor for displaying this sheet. |
See Also