The following tables list the members exposed by Worksheet.
Name | Description | |
---|---|---|
![]() | Columns | Gets the collection of columns in the worksheet. |
![]() | ConditionalFormats | Returns a collection to which conditions can be added to control the visual attributes of a WorksheetCell based on user-defined criteria. |
![]() | DataTables | Gets the collection of data tables in the worksheet. |
![]() | DataValidationRules | Gets the collection of data validation rules applied to cells in the Worksheet. |
![]() | DefaultColumnWidth | Gets or sets the default column width including padding, in 256ths of the '0' digit character width in the workbook's default font. |
![]() | DefaultRowHeight | Gets or sets the default row height in twips (1/20th of a point). |
![]() | DisplayOptions | Gets the object which controls the display of the worksheet. |
![]() | FilterSettings | Exposes methods to identify a region in the worksheet and to apply filters and optionally sort criteria to that region. |
![]() | HasProtectionPassword | Returns a boolean indicating if the Sheet has been protected with a password. (Inherited from Infragistics.Documents.Excel.Sheet) |
![]() | Hyperlinks | Gets the collection of hyperlinks applied to cells and regions in the Worksheet. |
![]() | ImageBackground | Gets or sets the background image for the worksheet. |
![]() | Index | Gets the zero-based index of this worksheet in its parent Workbook.Worksheets collection. |
![]() | IsProtected | Returns a boolean indicating if the Worksheet has been protected. (Inherited from Infragistics.Documents.Excel.Sheet) |
![]() | MergedCellsRegions | Gets the collection of merged cell ranges in this worksheet. |
![]() | Name | Gets or sets the sheet name. (Inherited from Infragistics.Documents.Excel.Sheet) |
![]() | PrintOptions | Gets the object which controls how the worksheet prints. |
![]() | Protected | Gets or sets the protection state of Excel worksheet. |
![]() | Protection | Returns an object that provides information used when the Worksheet has been protected. |
![]() | Rows | Gets the collection of rows in the worksheet. |
![]() | Selected | Gets the value which indicates whether this worksheet is selected. (Inherited from Infragistics.Documents.Excel.Sheet) |
![]() | Shapes | Gets the collection of shapes on the worksheet. |
![]() | SheetIndex | Gets the zero-based index of this sheet in its parent Workbook.Sheets collection. (Inherited from Infragistics.Documents.Excel.Sheet) |
![]() | SortSettings | Exposes methods to identify a region in the worksheet and to apply sort criteria to that region. |
![]() | SparklineGroups | Returns a collection of Infragistics.Documents.Excel.Sparklines.SparklineGroups (read-only) |
![]() | TabColorInfo | Gets or sets the WorkbookColorInfo to use for the associated sheet's tab in the tab bar of Microsoft Excel. (Inherited from Infragistics.Documents.Excel.Sheet) |
![]() | Tables | Gets the collection of WorksheetTable instances, or regions formatted as tables, in the worksheet. |
![]() | Type | Overridden. Returns a value indicating the type of sheet |
![]() | Workbook | Gets the Workbook that owns the worksheet. (Inherited from Infragistics.Documents.Excel.Sheet) |
Name | Description | |
---|---|---|
![]() | DeleteCells | Overloaded. Deletes a region of cells. |
![]() | GetCell | Overloaded. Gets the cell at the specified address or name. |
![]() | GetCellConditionalFormat | Gets the cell conditional format for the cell at the specified row and column index. |
![]() | GetDefaultColumnWidth | Gets the default column width in the specified units. |
![]() | GetRegion | Overloaded. Gets the region at the specified address or name. |
![]() | GetRegions | Overloaded. Gets the regions at the specified address or name. |
![]() | HideColumns | Hides the columns in the specified range. |
![]() | HideRows | Hides the rows in the specified range. |
![]() | InsertCells | Overloaded. Inserts a region of cells. |
![]() | MoveToIndex | Moves the worksheet to a new position in the owning workbook's collections of worksheets. |
![]() | MoveToSheetIndex | Moves the sheet to a new position in the owning workbook's collections of sheets. (Inherited from Infragistics.Documents.Excel.Sheet) |
![]() | Protect | Protects the worksheet without a password. |
![]() | SetDefaultColumnWidth | Sets the default column width in the specified units. |
![]() | UnhideColumns | Unhides the columns in the specified range. |
![]() | UnhideRows | Unhides the rows in the specified range. |
![]() | Unprotect | Removes the Sheet protection. (Inherited from Infragistics.Documents.Excel.Sheet) |
Name | Description | |
---|---|---|
![]() | PropertyChanged | Occurs after a property value has changed (Inherited from Infragistics.Documents.Excel.Sheet) |