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 | Overloaded. Protects the worksheet with the specified 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 | Overloaded. Attempts to use the specified password to remove the WorkSheet protection currently in place. (Inherited from Infragistics.Documents.Excel.Sheet) |
Name | Description | |
---|---|---|
PropertyChanged | Occurs after a property value has changed (Inherited from Infragistics.Documents.Excel.Sheet) |