In This Topic ▼
Sheet Class Members
Summary
The following tables list the members exposed by Sheet.
Public Methods
| Name | Description | |
|---|---|---|
 |
CreateColumns | Creates new columns and inserts them at the specified index within the sheet. |
|
CreateRow | Creates a new row and inserts it at the specified index within the sheet. |
|
CreateRows | Creates new rows and inserts them at the specified index within the sheet. |
|
GetColumnWidthInPixel | Retrieves the width of a specified column within the sheet. |
|
GetRowAt | Retrieves the row at the specified index within the sheet. |
|
GetRowHeightInPixel | Retrieves the height of a specified row within the sheet. |
|
IsColumnHidden | Determines the visibility status of an individual column. |
|
IsRowHidden | Determines the visibility status of an individual row. |
|
RemoveColumns | Removes a specific number of columns from a sheet, starting from a given index. |
|
RemoveRows | Removes a specific number of rows from a sheet, starting from a given index. |
|
SetCellRangeBorder | Sets the border style for a specified border of the cell range. |
|
SetColumnHidden | Changes the visibility status of an individual column. |
|
SetColumnWidthInPixel | Adjusts the width of a specified column within the sheet, measured in pixels. |
|
SetRowHeightInPixel | Adjusts the height of a specified row within the sheet, measured in pixels. |
|
SetRowHidden | Changes the visibility status of an individual row. |
|
SortCellRange | Sorts a specified range of cells within the sheet according to a set of defined sorting options. |
Public Properties
| Name | Description | |
|---|---|---|
 |
ColumnsCount | Gets the number of columns in a sheet. |
|
DefaultColumnWidth | Gets or sets the default width for columns within the sheet. This property specifies the standard width applied to columns in the absence of specific column width settings. |
|
DefaultRowHeight | Gets or sets the default height for rows within the sheet. This property defines the standard height applied to rows in the absence of specific row height settings. |
|
FirstRowIndex | Gets the index of the first non-empty row within the sheet. This property identifies the starting point of data or content within a sheet, enabling targeted operations on rows that contain information. |
|
Images | Provides access to the SheetImages collection associated with the sheet. |
|
LastRowIndex | Gets the index of the last non-empty row within the sheet. |
|
MergedRegions | Provides access to the MergedCellRegions collection associated with the sheet.This property enables the management of merged cell regions within the sheet, offering functionalities to add, remove, or access merged regions. |
|
Name | Gets or sets the sheet name. |
|
RowsCount | Gets the number of rows in a sheet. |
