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) |