For a list of all members of this type, see Worksheet members.
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) |