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. |