The following tables list the members exposed by Sheet.
Name | Description | |
---|---|---|
CreateColumns | Creates a specified number of new columns starting from a given index within the sheet. | |
CreateRow | Creates a new row at the specified index within the sheet. | |
CreateRows | Creates a specified number of new rows starting from a given index within the sheet. | |
GetColumnWidthInPixel | Retrieves the width of a specified column within the sheet. | |
GetEnumerator | Overrides Objects.GetEnumerator. | |
GetRowAt | Retrieves the row at the specified index within the sheet. | |
GetRowHeightInPixel | Retrieves the height of a specified row within the sheet. | |
IsColumnHidden | Determines whether a specified column within the sheet is hidden. Allows for checking the visibility status of individual columns. | |
IsRowHidden | Determines whether a specified row within the sheet is hidden. | |
RemoveColumns | Removes a specified number of columns starting from a given index within the sheet. | |
RemoveRows | Removes a specified number of rows starting from a given index within the sheet. | |
SetColumnHidden | Hides or reveals a specified column within the sheet. | |
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 | Hides or reveals a specified row within the sheet. | |
SortCellRange | Sorts a specified range of cells within the sheet according to a set of defined sorting options. |
Name | Description | |
---|---|---|
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 is instrumental in identifying 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 name of the sheet. This property allows for the identification and customization of the sheet name within a workbook, facilitating easy navigation and reference among multiple sheets. |