Worksheet Properties

The Worksheet type exposes the following members.

Properties
  NameDescription
Public propertyActiveCell
Gets or sets the active cell in the worksheet.
Public propertyAllowEditRanges
Gets the allow edit range collection in the worksheet.
Public propertyAutoFilter
Represents auto filter for the specified worksheet.
Public propertyBackgroundImage
Gets and sets worksheet background image.
Public propertyCells
Gets the Cells collection.
Public propertyCellWatches
Gets collection of cells on this worksheet being watched in the 'watch window'.
Public propertyCharts
Gets a Chart collection
Public propertyCheckBoxes
Gets a CheckBox collection.
Public propertyCodeName
Gets worksheet code name.
Public propertyComments
Gets the Comment collection.
Public propertyConditionalFormattings
Gets the ConditionalFormattings in the worksheet.
Public propertyCustomProperties
Gets an object representing the identifier information associated with a worksheet.
Public propertyDisplayRightToLeft
Indicates if the specified worksheet is displayed from right to left instead of from left to right. Default is false.
Public propertyDisplayZeros
True if zero values are displayed.
Public propertyErrorCheckOptions
Gets error check setting applied on certain ranges.
Public propertyFirstVisibleColumn
Represents first visible column index.
Public propertyFirstVisibleRow
Represents first visible row index.
Public propertyHasAutofilter
Indicates whether this worksheet has auto filter.
Public propertyHorizontalPageBreaks
Gets the HorizontalPageBreakCollection collection.
Public propertyHyperlinks
Gets the HyperlinkCollection collection.
Public propertyIndex
Gets the index of sheet in the worksheet collection.
Public propertyIsGridlinesVisible
Gets or sets a value indicating whether the gridelines are visible.Default is true.
Public propertyIsOutlineShown
Indicates whether to show outline.
Public propertyIsPageBreakPreview
Indicates whether the specified worksheet is shown in normal view or page break preview.
Public propertyIsProtected
Indicates if the worksheet is protected.
Public propertyIsRowColumnHeadersVisible
Gets or sets a value indicating whether the worksheet will display row and column headers. Default is true.
Public propertyIsRulerVisible
Indicates whether the ruler is visible. This property is only applied for page break preview.
Public propertyIsSelected
Indicates whether this worksheet is selected when the workbook is opened.
Public propertyIsVisible
Represents if the worksheet is visible.
Public propertyListObjects
Gets all ListObjects in this worksheet.
Public propertyName
Gets or sets the name of the worksheet.
Public propertyOleObjects
Represents a collection of OleObject in a worksheet.
Public propertyOutline
Gets the outline on this worksheet.
Public propertyPageSetup
Represents the page setup description in this sheet.
Public propertyPictures
Gets a Picture collection.
Public propertyPivotTables
Gets all pivot tables in this worksheet.
Public propertyProtection
Represents the various types of protection options available for a worksheet. Supports advanced protection options in ExcelXP and above version.
Public propertyQueryTables
Gets the queryTables in the worksheet.
Public propertyScenarios
Gets the collection of Scenario.
Public propertyShapes
Returns all drawing shapes in this worksheet.
Public propertyShowFormulas
Indicates whether to show formulas or their results.
Public propertySlicers
Get the Slicer collection in the worksheet
Public propertySmartTagSetting
Gets all SmartTagCollection objects of the worksheet.
Public propertySparklineGroupCollection
Gets the sparkline group collection in the worksheet.
Public propertyTabColor
Represents worksheet tab color.
Public propertyTabId
Specifies the internal identifier for the sheet.
Public propertyTextBoxes
Gets a TextBox collection.
Public propertyTransitionEntry
Indicates whether the Transition Formula Entry (Lotus compatibility) option is enabled.
Public propertyTransitionEvaluation
Indicates whether the Transition Formula Evaluation (Lotus compatibility) option is enabled.
Public propertyType
Represents worksheet type.
Public propertyValidations
Gets the data validation setting collection in the worksheet.
Public propertyVerticalPageBreaks
Gets the VerticalPageBreakCollection collection.
Public propertyViewType
Gets and sets the view type.
Public propertyVisibilityType
Indicates the visible state for this sheet.
Public propertyWorkbook
Gets the workbook object which contains this sheet.
Public propertyZoom
Represents the scaling factor in percentage. It should be between 10 and 400.
See Also