WorksheetClass Members

  • Article

Include Protected Members
Include Inherited Members

Reserved for internal use.

The WorksheetClass type exposes the following members.

Constructors

  Name Description
Public method WorksheetClass

Top

Properties

  Name Description
Public property _CodeName
Public property _DisplayRightToLeft
Public property Application
Public property AutoFilter
Public property AutoFilterMode
Public property Cells
Public property CircularReference
Public property CodeName
Public property Columns
Public property Comments
Public property ConsolidationFunction
Public property ConsolidationOptions
Public property ConsolidationSources
Public property Creator
Public property CustomProperties
Public property DisplayAutomaticPageBreaks
Public property DisplayPageBreaks
Public property DisplayRightToLeft
Public property EnableAutoFilter
Public property EnableCalculation
Public property EnableFormatConditionsCalculation
Public property EnableOutlining
Public property EnablePivotTable
Public property EnableSelection
Public property FilterMode
Public property HPageBreaks
Public property Hyperlinks
Public property Index
Public property ListObjects
Public property MailEnvelope
Public property Name
Public property Names
Public property Next
Public property OnCalculate
Public property OnData
Public property OnDoubleClick
Public property OnEntry
Public property OnSheetActivate
Public property OnSheetDeactivate
Public property Outline
Public property PageSetup
Public property Parent
Public property Previous
Public property PrintedCommentPages
Public property ProtectContents
Public property ProtectDrawingObjects
Public property Protection
Public property ProtectionMode
Public property ProtectScenarios
Public property QueryTables
Public property Range
Public property Rows
Public property Scripts
Public property ScrollArea
Public property Shapes
Public property SmartTags
Public property Sort
Public property StandardHeight
Public property StandardWidth
Public property Tab
Public property TransitionExpEval
Public property TransitionFormEntry
Public property Type
Public property UsedRange
Public property Visible
Public property VPageBreaks

Top

Methods

  Name Description
Public method _CheckSpelling
Public method _Evaluate
Public method _PasteSpecial
Public method _PrintOut
Public method _Protect
Public method _SaveAs
Public method Activate
Public method add_Activate
Public method add_BeforeDoubleClick
Public method add_BeforeRightClick
Public method add_Calculate
Public method add_Change
Public method add_Deactivate
Public method add_FollowHyperlink
Public method add_PivotTableAfterValueChange
Public method add_PivotTableBeforeAllocateChanges
Public method add_PivotTableBeforeCommitChanges
Public method add_PivotTableBeforeDiscardChanges
Public method add_PivotTableChangeSync
Public method add_PivotTableUpdate
Public method add_SelectionChange
Public method Arcs
Public method Buttons
Public method Calculate
Public method ChartObjects
Public method CheckBoxes
Public method CheckSpelling
Public method CircleInvalid
Public method ClearArrows
Public method ClearCircles
Public method Copy
Public method Delete
Public method DrawingObjects
Public method Drawings
Public method DropDowns
Public method Equals (Inherited from Object.)
Public method Evaluate
Public method ExportAsFixedFormat
Protected method Finalize (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Public method GroupBoxes
Public method GroupObjects
Public method Labels
Public method Lines
Public method ListBoxes
Protected method MemberwiseClone (Inherited from Object.)
Public method Move
Public method OLEObjects
Public method OptionButtons
Public method Ovals
Public method Paste
Public method PasteSpecial
Public method Pictures
Public method PivotTables
Public method PivotTableWizard
Public method PrintOut
Public method PrintOutEx
Public method PrintPreview
Public method Protect
Public method Rectangles
Public method remove_Activate
Public method remove_BeforeDoubleClick
Public method remove_BeforeRightClick
Public method remove_Calculate
Public method remove_Change
Public method remove_Deactivate
Public method remove_FollowHyperlink
Public method remove_PivotTableAfterValueChange
Public method remove_PivotTableBeforeAllocateChanges
Public method remove_PivotTableBeforeCommitChanges
Public method remove_PivotTableBeforeDiscardChanges
Public method remove_PivotTableChangeSync
Public method remove_PivotTableUpdate
Public method remove_SelectionChange
Public method ResetAllPageBreaks
Public method SaveAs
Public method Scenarios
Public method ScrollBars
Public method Select
Public method SetBackgroundPicture
Public method ShowAllData
Public method ShowDataForm
Public method Spinners
Public method TextBoxes
Public method ToString (Inherited from Object.)
Public method Unprotect
Public method XmlDataQuery
Public method XmlMapQuery

Top

Events

  Name Description
Public event BeforeDoubleClick
Public event BeforeRightClick
Public event Change
Public event Deactivate
Public event DocEvents_Event_Activate
Public event DocEvents_Event_Calculate
Public event FollowHyperlink
Public event PivotTableAfterValueChange
Public event PivotTableBeforeAllocateChanges
Public event PivotTableBeforeCommitChanges
Public event PivotTableBeforeDiscardChanges
Public event PivotTableChangeSync
Public event PivotTableUpdate
Public event SelectionChange

Top

See Also

Reference

WorksheetClass Class

Microsoft.Office.Interop.Excel Namespace