Worksheet Properties |
The Worksheet type exposes the following members.
Name | Description | |
---|---|---|
![]() | ActiveCell |
Gets or sets the active cell in the worksheet.
|
![]() | AllowEditRanges |
Gets the allow edit range collection in the worksheet.
|
![]() | AutoFilter |
Represents auto filter for the specified worksheet.
|
![]() | BackgroundImage |
Gets and sets worksheet background image.
|
![]() | Cells |
Gets the Cells collection.
|
![]() | CellWatches |
Gets collection of cells on this worksheet being watched in the 'watch window'.
|
![]() | Charts |
Gets a Chart collection
|
![]() | CheckBoxes |
Gets a CheckBox collection.
|
![]() | CodeName |
Gets worksheet code name.
|
![]() | Comments |
Gets the Comment collection.
|
![]() | ConditionalFormattings |
Gets the ConditionalFormattings in the worksheet.
|
![]() | CustomProperties |
Gets an object representing
the identifier information associated with a worksheet.
|
![]() | DisplayRightToLeft |
Indicates if the specified worksheet is displayed from right to left instead of from left to right.
Default is false.
|
![]() | DisplayZeros |
True if zero values are displayed.
|
![]() | ErrorCheckOptions |
Gets error check setting applied on certain ranges.
|
![]() | FirstVisibleColumn |
Represents first visible column index.
|
![]() | FirstVisibleRow |
Represents first visible row index.
|
![]() | HasAutofilter |
Indicates whether this worksheet has auto filter.
|
![]() | HorizontalPageBreaks |
Gets the HorizontalPageBreakCollection collection.
|
![]() | Hyperlinks |
Gets the HyperlinkCollection collection.
|
![]() | Index |
Gets the index of sheet in the worksheet collection.
|
![]() | IsGridlinesVisible |
Gets or sets a value indicating whether the gridlines are visible.Default is true.
|
![]() | IsOutlineShown |
Indicates whether to show outline.
|
![]() | IsPageBreakPreview |
Indicates whether the specified worksheet is shown in normal view or page break preview.
|
![]() | IsProtected |
Indicates if the worksheet is protected.
|
![]() | IsRowColumnHeadersVisible |
Gets or sets a value indicating whether the worksheet will display row and column headers.
Default is true.
|
![]() | IsRulerVisible |
Indicates whether the ruler is visible. This property is only applied for page break preview.
|
![]() | IsSelected |
Indicates whether this worksheet is selected when the workbook is opened.
|
![]() | IsVisible |
Represents if the worksheet is visible.
|
![]() | ListObjects |
Gets all ListObjects in this worksheet.
|
![]() | Name |
Gets or sets the name of the worksheet.
|
![]() | OleObjects |
Represents a collection of OleObject in a worksheet.
|
![]() | Outline |
Gets the outline on this worksheet.
|
![]() | PageSetup |
Represents the page setup description in this sheet.
|
![]() | PaneState |
Indicates whether the pane has horizontal or vertical splits, and whether those splits are frozen.
|
![]() | Pictures |
Gets a Picture collection.
|
![]() | PivotTables |
Gets all pivot tables in this worksheet.
|
![]() | Protection |
Represents the various types of protection options available for a worksheet. Supports advanced protection options in ExcelXP and above version.
|
![]() | QueryTables |
Gets QueryTableCollection in the worksheet.
|
![]() | Scenarios |
Gets the collection of Scenario.
|
![]() | Shapes |
Returns all drawing shapes in this worksheet.
|
![]() | ShowFormulas |
Indicates whether to show formulas or their results.
|
![]() | Slicers |
Get the Slicer collection in the worksheet
|
![]() | SmartTagSetting |
Gets all SmartTagCollection objects of the worksheet.
|
![]() | SparklineGroupCollection |
Gets the sparkline group collection in the worksheet.
|
![]() | TabColor |
Represents worksheet tab color.
|
![]() | TabId |
Specifies the internal identifier for the sheet.
|
![]() | TextBoxes |
Gets a TextBox collection.
|
![]() | Timelines |
Get the Timeline collection in the worksheet
|
![]() | TransitionEntry |
Indicates whether the Transition Formula Entry (Lotus compatibility) option is enabled.
|
![]() | TransitionEvaluation |
Indicates whether the Transition Formula Evaluation (Lotus compatibility) option is enabled.
|
![]() | Type |
Represents worksheet type.
|
![]() | UniqueId |
Gets and sets the unique id, it is same as {15DB5C3C-A5A1-48AF-8F25-3D86AC232D4F}.
|
![]() | Validations |
Gets the data validation setting collection in the worksheet.
|
![]() | VerticalPageBreaks |
Gets the VerticalPageBreakCollection collection.
|
![]() | ViewType |
Gets and sets the view type.
|
![]() | VisibilityType |
Indicates the visible state for this sheet.
|
![]() | Workbook |
Gets the workbook object which contains this sheet.
|
![]() | Zoom |
Represents the scaling factor in percentage. It should be between 10 and 400.
|