Export (0) Print
Expand All

Worksheet Members

The Microsoft.Office.Tools.Excel.Worksheet host item is a Microsoft.Office.Interop.Excel.Worksheet object that exposes events and acts as a container for controls.

The following tables list the members exposed by the Worksheet type.

  Name Description
Public constructor Worksheet Overloaded.
Top

(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

  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 Protected Methods )
  Name Description
Public method _CheckSpelling
Public method _Evaluate
Public method _PasteSpecial
Public method _PrintOut
Public method _Protect
Public method _SaveAs
Public method Activate Makes the current sheet the active sheet.  
Public method Arcs
Public method BeginInit
Public method Buttons
Public method CalculateMethod Calculates the formulas in the worksheet.  
Public method ChartObjects Gets an object that represents either a single embedded chart (a Microsoft.Office.Interop.Excel.ChartObject) or a collection of all the embedded charts (a Microsoft.Office.Interop.Excel.ChartObjects) on the worksheet.  
Public method CheckBoxes
Public method CheckSpelling Checks the spelling in a worksheet.  
Public method CircleInvalid Circles invalid entries on the worksheet.  
Public method ClearArrows Clears the tracer arrows from the worksheet. Tracer arrows are added by using the auditing feature.  
Public method ClearCircles Clears circles from invalid entries on the worksheet.  
Public method Copy Copies the worksheet to another location in the workbook.  
Public method CreateObjRef  (Inherited from MarshalByRefObject.)
Public method Delete Deletes the underlying Microsoft.Office.Interop.Excel.Worksheet object, but does not delete the host item. It is highly recommended that this method not be used.  
Public method Dispose Overloaded. Releases the unmanaged resources used by the Worksheet and optionally releases the managed resources.  
Public method DrawingObjects
Public method Drawings
Public method DropDowns
Public method EndInit
Public method Equals  Overloaded. (Inherited from Object.)
Public method Evaluate Converts a Microsoft Office Excel name to an object or a value.  
Public method get_Range
Public method GetHashCode  (Inherited from Object.)
Public method GetLifetimeService  (Inherited from MarshalByRefObject.)
Public method GetType  (Inherited from Object.)
Public method GroupBoxes
Public method GroupObjects
Public method InitializeLifetimeService  (Inherited from MarshalByRefObject.)
Public method Labels
Public method Lines
Public method ListBoxes
Public method Move Moves the worksheet to another location in the workbook.  
Public method OLEObjects Gets an object that represents either a single OLE object (an Microsoft.Office.Interop.Excel.OLEObject) or a collection of all OLE objects (an Microsoft.Office.Interop.Excel.OLEObjects collection) on the worksheet.  
Public method OnShutdown
Public method OnStartup
Public method OptionButtons
Public method Ovals
Public method Paste Pastes the contents of the Clipboard onto the worksheet.  
Public method PasteSpecial Pastes the contents of the Clipboard onto the worksheet, using a specified format. Use this method to paste data from other applications or to paste data in a specific format.  
Public method Pictures
Public method PivotTables Gets an object that represents either a single PivotTable report (a Microsoft.Office.Interop.Excel.PivotTable object) or a collection of all the PivotTable reports (a Microsoft.Office.Interop.Excel.PivotTables object) on a worksheet.  
Public method PivotTableWizard Creates a Microsoft.Office.Interop.Excel.PivotTable object.  
Public method PrintOut Prints the worksheet.  
Public method PrintPreview Shows a preview of the worksheet as it would look when printed.  
Public method Protect Protects a worksheet so that it cannot be modified.  
Public method Rectangles
Public method Static ReferenceEquals  (Inherited from Object.)
Public method ResetAllPageBreaks Resets all page breaks on the specified worksheet.  
Public method SaveAs Saves changes to the worksheet in a different file.  
Public method Scenarios Gets an object that represents either a single scenario (a Microsoft.Office.Interop.Excel.Scenario object) or a collection of scenarios (a Microsoft.Office.Interop.Excel.Scenarios object) on the worksheet.  
Public method ScrollBars
Public method Select Selects the worksheet.  
Public method SetBackgroundPicture Sets the background graphic for the worksheet.  
Public method ShowAllData Makes all rows of the currently filtered list visible. If AutoFilter is in use, this method changes the arrows to "All."  
Public method ShowDataForm Displays the data form associated with the worksheet.  
Public method Spinners
Public method TextBoxes
Public method ToString  (Inherited from Component.)
Public method Unprotect Removes protection from the worksheet. This method has no effect if the worksheet is not protected.  
Public method XmlDataQuery Gets a Range object that represents the cells mapped to a particular XPath. Gets a null reference (Nothing in Visual Basic) if the specified XPath has not been mapped to the worksheet, or if the mapped range is empty.  
Public method XmlMapQuery Gets a Range object that represents the cells mapped to a particular XPath. Gets a null reference (Nothing in Visual Basic) if the specified XPath has not been mapped to the worksheet.  
Top

  Name Description
Protected method Dispose Overloaded. Overridden. Releases the unmanaged resources used by the Worksheet and optionally releases the managed resources.  
Protected method Finalize  (Inherited from Component.)
Protected method GetObjects
Protected method GetPrimaryControl
Protected method GetService  (Inherited from Component.)
Protected method MemberwiseClone  Overloaded. (Inherited from MarshalByRefObject.)
Protected method OnBindingContextChanged  (Inherited from BindableComponent.)
Top

  Name Description
Public event ActivateEvent Occurs when the worksheet is activated. 
Public event BeforeDoubleClick Occurs when the worksheet is double-clicked, before the default double-click action. 
Public event BeforeRightClick Occurs when the worksheet is right-clicked, before the default right-click action. 
Public event BindingContextChanged  (Inherited from BindableComponent.)
Public event Calculate Occurs after the worksheet is recalculated. 
Public event Change Occurs when something changes in the Worksheet cells. 
Public event Deactivate Occurs when the worksheet loses focus. 
Public event Disposed  (Inherited from Component.)
Public event FollowHyperlink Occurs when you click any hyperlink on a worksheet. 
Public event PivotTableUpdate Occurs after a PivotTable report is updated on a worksheet. 
Public event SelectionChange Occurs when the selection changes on a worksheet. 
Public event Shutdown Occurs when the application domain for the assembly is about to unload. 
Public event Startup Occurs after the worksheet is running and all the initialization code in the assembly has been run. 
Top
Show:
© 2014 Microsoft