Excel Object Model Reference (Visual Studio Tools for Office)
Worksheet Properties

Public Properties
(see also Protected Properties )
  Name Description
Public property _CodeName
Public property _DisplayRightToLeft
Public property Application This property gets a Microsoft.Office.Interop.Excel.Application that represents the Microsoft Office Excel application. 
Public property AutoFilter Gets a Microsoft.Office.Interop.Excel.AutoFilter if filtering is on. Gets a null reference (Nothing in Visual Basic) if filtering is off. 
Public property AutoFilterMode Gets or sets a value that indicates whether the AutoFilter drop-down arrows are currently displayed on the sheet. 
Public property BindingContext  (Inherited from BindableComponent.)
Public property Cells Gets a Range object that represents all the cells on the worksheet (not just the cells that are currently in use). 
Public property CircularReference Gets a Range object that represents the range containing the first circular reference on the sheet, or gets a null reference (Nothing in Visual Basic) if there is no circular reference on the sheet. 
Public property CodeName
Public property Columns Gets a Range object that represents all the columns on the worksheet. 
Public property Comments Gets a Microsoft.Office.Interop.Excel.Comments collection that represents all the comments for the worksheet. 
Public property ConsolidationFunction Gets the function code used for the current consolidation. 
Public property ConsolidationOptions Gets a three-element Array of consolidation options.  
Public property ConsolidationSources Gets an Array of strings that name the source sheets and ranges for the worksheet's current consolidation.  
Public property Container  (Inherited from Component.)
Public property Controls Gets the collection of controls contained within the worksheet. 
Public property Creator Gets a value that indicates the application in which the worksheet was created. 
Public property CustomProperties Gets a Microsoft.Office.Interop.Excel.CustomProperties object representing the identifier information associated with a worksheet. 
Public property DataBindings  (Inherited from BindableComponent.)
Public property DisplayAutomaticPageBreaks
Public property DisplayPageBreaks Gets or sets a value that indicates whether page breaks (both automatic and manual) on the worksheet are displayed. 
Public property DisplayRightToLeft Gets or sets a value that indicates whether the worksheet is displayed from right to left instead of from left to right. 
Public property EnableAutoFilter Gets or sets a value that indicates whether AutoFilter arrows are enabled when user-interface-only protection is turned on. 
Public property EnableCalculation Gets or set a value that indicates whether Microsoft Office Excel automatically recalculates the worksheet when necessary. 
Public property EnableOutlining Gets or sets a value that indicates whether outlining symbols are enabled when user-interface-only protection is turned on. 
Public property EnablePivotTable Gets or sets a value that indicates whether PivotTable controls and actions are enabled when user-interface-only protection is turned on. 
Public property EnableSelection Gets or sets a value indicating which cells can be selected on the sheet. 
Public property FilterMode Gets a value that indicates whether the worksheet is in filter mode. 
Public property HPageBreaks Gets an Microsoft.Office.Interop.Excel.HPageBreaks collection that represents the horizontal page breaks on the sheet. 
Public property Hyperlinks Gets a Microsoft.Office.Interop.Excel.Hyperlinks collection that represents the hyperlinks for the range or worksheet. 
Public property Index Gets the index number of the worksheet within the collection of worksheets. 
Public property InnerObject Gets a Microsoft.Office.Interop.Excel.Worksheet that represents the underlying native object for the Worksheet. 
Public property ListObjects Gets a collection of Microsoft.Office.Interop.Excel.ListObject objects in the worksheet. 
Public property MailEnvelope Gets an e-mail header for the worksheet. 
Public property Name Gets or sets the name of the worksheet. 
Public property Names Gets a Microsoft.Office.Interop.Excel.Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix). 
Public property Next Gets a Microsoft.Office.Interop.Excel.Worksheet that represents the next sheet. 
Public property OnCalculate
Public property OnData
Public property OnDoubleClick
Public property OnEntry
Public property OnSheetActivate
Public property OnSheetDeactivate
Public property Outline Gets an Microsoft.Office.Interop.Excel.Outline that represents the outline for the worksheet. 
Public property PageSetup Gets a Microsoft.Office.Interop.Excel.PageSetup that contains all the page setup settings for the worksheet. 
Public property Parent Gets the parent object for the worksheet. 
Public property Previous Gets a Microsoft.Office.Interop.Excel.Worksheet that represents the previous sheet. 
Public property ProtectContents Gets a value that indicates whether the contents of the worksheet (the individual cells) are protected. 
Public property ProtectDrawingObjects Gets a value that indicates whether shapes are protected. 
Public property Protection Gets a Microsoft.Office.Interop.Excel.Protection object that represents the protection options of the worksheet. 
Public property ProtectionMode Gets a value that indicates whether user interface-only protection is turned on. 
Public property ProtectScenarios Gets a value that indicates whether worksheet scenarios are protected. 
Public property QueryTables Gets the Microsoft.Office.Interop.Excel.QueryTables collection that represents all the query tables on the worksheet. 
Public property Range Gets a Microsoft.Office.Interop.Excel.Range object that represents a cell or a range of cells. 
Public property Rows Gets a Range object that represents all the rows on the worksheet. 
Public property Scripts Gets the Microsoft.Office.Core.Scripts collection, which contains Script objects representing blocks of script or code in the worksheet when it is saved as a Web page. 
Public property ScrollArea Gets or sets the range where scrolling is allowed, as an A1-style range reference. 
Public property Shapes Gets a Microsoft.Office.Interop.Excel.Shapes object that represents all the shapes on the worksheet. 
Public property Site  (Inherited from Component.)
Public property SmartTags Gets a Microsoft.Office.Interop.Excel.SmartTags object representing the collection of smart tags for the worksheet. 
Public property StandardHeight Gets the standard (default) height of all the rows in the worksheet, in points. 
Public property StandardWidth Gets or sets the standard (default) width of all the columns in the worksheet. 
Public property Tab Gets a Microsoft.Office.Interop.Excel.Tab for the worksheet. 
Public property Tag Gets or sets the object that contains data about the worksheet. 
Public property TransitionExpEval Gets or sets a value that indicates whether Microsoft Office Excel uses Lotus 1-2-3 expression evaluation rules for the worksheet. 
Public property TransitionFormEntry Gets or sets a value that indicates whether Microsoft Office Excel uses Lotus 1-2-3 formula entry rules for the worksheet. 
Public property Type Gets the worksheet type. 
Public property UsedRange Gets a Microsoft.Office.Interop.Excel.Range object that represents the used range on the worksheet. 
Public property Visible Gets or sets a Microsoft.Office.Interop.Excel.XlSheetVisibility value that determines whether the object is visible. 
Public property VPageBreaks Gets a Microsoft.Office.Interop.Excel.VPageBreaks collection that represents the vertical page breaks on the sheet. 
Top
Protected Properties
  Name Description
Protected property CanRaiseEvents  (Inherited from Component.)
Protected property ContainerComponent  (Inherited from BindableComponent.)
Protected property DesignMode  (Inherited from Component.)
Protected property Events  (Inherited from Component.)
Top
See Also
Page view tracker