Worksheet Members (2007 System)
Include Protected Members
Include Inherited Members
Represents a worksheet that exposes events and acts as a container for controls in Visual Studio Tools for Office projects for Microsoft Office Excel.
The Worksheet type exposes the following members.
Constructors
Name
Description
.gif "Public method")
Infrastructure. Overloaded.
Top
Methods
Name
Description
Infrastructure.
Infrastructure.
Infrastructure.
Infrastructure.
Infrastructure.
Infrastructure.
Makes the current sheet the active sheet.
Infrastructure.
Infrastructure.
Infrastructure.
Calculates the formulas in the worksheet.
Gets an object that represents either a single embedded chart (a ChartObject) or a collection of all the embedded charts (a ChartObjects) on the worksheet.
Infrastructure.
Checks the spelling in a worksheet.
.gif "Protected method")
(Inherited from RemoteComponent.)
Circles invalid entries on the worksheet.
Clears the tracer arrows from the worksheet. Tracer arrows are added by using the auditing feature.
Clears circles from invalid entries on the worksheet.
Copies the worksheet to another location in the workbook.
Deletes the underlying Worksheet object, but does not delete the host item. It is highly recommended that this method not be used.
Overloaded. Releases the unmanaged resources used by the Worksheet and optionally releases the managed resources.
Infrastructure.
Infrastructure.
Infrastructure.
Infrastructure.
Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Converts a Microsoft Office Excel name to an object or a value.
Exports to a file of the specified format.
(Inherited from RemoteComponent.)
(Inherited from EntryPointComponentBase.)
Infrastructure. Use the Range property instead of this method.
Called by the Visual Studio Tools for Office runtime to get an object that can be used by VBA code in the worksheet.
Serves as a hash function for a particular type. (Inherited from Object.)
(Inherited from RemoteComponent.)
Infrastructure.
(Inherited from RemoteComponent.)
Gets the type of the current instance. (Inherited from Object.)
.gif "Static member")
Returns an Excel worksheet host item that extends the functionality of the specified native Excel worksheet.
Infrastructure.
Infrastructure.
Returns a value that indicates whether an Excel Microsoft.Office.Tools.Excel.Worksheet host item has been created for the specified native Excel _Worksheet.
Infrastructure. (Overrides EntryPointComponentBase.Initialize().)
(Inherited from RemoteComponent.)
(Inherited from EntryPointComponentBase.)
Infrastructure.
Infrastructure.
Infrastructure.
Creates a shallow copy of the current Object. (Inherited from Object.)
Moves the worksheet to another location in the workbook.
Gets an object that represents either a single OLE object (an OLEObject) or a collection of all OLE objects (an OLEObjects collection) on the worksheet.
(Inherited from EntryPointBindableComponentBase.)
Infrastructure. (Overrides EntryPointComponentBase.OnShutdown().)
Infrastructure. (Overrides EntryPointComponentBase.OnStartup().)
Infrastructure.
Infrastructure.
Pastes the contents of the Clipboard onto the worksheet.
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.
Infrastructure.
Gets an object that represents either a single PivotTable report (a PivotTable object) or a collection of all the PivotTable reports (a PivotTables object) on a worksheet.
Creates a PivotTable object.
Prints the worksheet.
Prints the worksheet.
Shows a preview of the worksheet as it would look when printed.
Protects a worksheet so that it cannot be modified.
Infrastructure.
Resets all page breaks on the specified worksheet.
Saves changes to the worksheet in a different file.
Gets an object that represents either a single scenario (a Scenario object) or a collection of scenarios (a Scenarios object) on the worksheet.
Infrastructure.
Selects the worksheet.
Sets the background graphic for the worksheet.
(Inherited from RemoteComponent.)
Makes all rows of the currently filtered list visible. If AutoFilter is in use, this method changes the arrows to "All."
Displays the data form associated with the worksheet.
Infrastructure.
Infrastructure.
Returns a string that represents the current object. (Inherited from Object.)
Removes protection from the worksheet. This method has no effect if the worksheet is not protected.
Gets a Range object that represents the cells mapped to a particular XPath. Gets nulla null reference (Nothing in Visual Basic) if the specified XPath has not been mapped to the worksheet, or if the mapped range is empty.
Gets a Range object that represents the cells mapped to a particular XPath. Gets nulla null reference (Nothing in Visual Basic) if the specified XPath has not been mapped to the worksheet.
Top
Properties
Name
Description
.gif "Public property")
Infrastructure.
Infrastructure.
This property gets a Application that represents the Microsoft Office Excel application.
Gets a AutoFilter that provides information about filtered lists on the worksheet if filtering is enabled. Gets nulla null reference (Nothing in Visual Basic) if filtering is off.
Gets or sets a value that indicates whether filtering is currently enabled on the worksheet (that is, whether the filter drop-down arrows are currently displayed).
(Inherited from EntryPointBindableComponentBase.)
Gets a Range object that represents all the cells on the worksheet (not just the cells that are currently in use).
Gets a Range object that represents the range containing the first circular reference on the sheet, or gets nulla null reference (Nothing in Visual Basic) if there is no circular reference on the sheet.
Infrastructure.
Gets a Range object that represents one or more columns on the worksheet.
Gets a Comments collection that represents all the comments for the worksheet.
Gets the function code used for the current consolidation.
Gets a three-element Array of consolidation options.
Gets an Array of strings that name the source sheets and ranges for the worksheet's current consolidation.
(Inherited from RemoteComponent.)
(Inherited from EntryPointBindableComponentBase.)
Gets the collection of managed controls that are contained on the worksheet.
Gets a value that indicates the application in which the worksheet was created.
Gets a CustomProperties object representing the identifier information associated with a worksheet.
(Inherited from EntryPointBindableComponentBase.)
.gif "Protected property")
(Inherited from EntryPointComponentBase.)
(Inherited from EntryPointBindableComponentBase.)
(Inherited from RemoteComponent.)
Infrastructure.
Gets or sets a value that indicates whether page breaks (both automatic and manual) on the worksheet are displayed.
Gets or sets a value that indicates whether the worksheet is displayed from right to left instead of from left to right.
Gets or sets a value that indicates whether AutoFilter arrows are enabled when user-interface-only protection is turned on.
Gets or set a value that indicates whether Microsoft Office Excel automatically recalculates the worksheet when necessary.
EnableFormatConditionsCalculation
Gets or sets a value that determines whether conditional formats will occur automatically.
Gets or sets a value that indicates whether outlining symbols are enabled when user-interface-only protection is turned on.
Gets or sets a value that indicates whether PivotTable controls and actions are enabled when user-interface-only protection is turned on.
Gets or sets a value indicating which cells can be selected on the sheet.
Gets a value that indicates whether the worksheet is actively filtering data.
(Inherited from RemoteComponent.)
Gets an HPageBreaks collection that represents the horizontal page breaks on the sheet.
Gets a Hyperlinks collection that represents the hyperlinks for the range or worksheet.
(Inherited from RemoteComponent.)
Gets the index number of the worksheet within the collection of worksheets.
Gets a Worksheet that represents the underlying native object for the Worksheet.
(Inherited from RemoteComponent.)
(Inherited from RemoteComponent.)
Gets a collection of ListObject objects in the worksheet.
Gets an e-mail header for the worksheet.
Gets or sets the name of the worksheet.
Gets a Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix).
Gets a Worksheet that represents the next sheet.
Infrastructure.
Infrastructure.
Infrastructure.
Infrastructure.
Infrastructure.
Infrastructure.
Gets an Outline that represents the outline for the worksheet.
Gets a PageSetup that contains all the page setup settings for the worksheet.
Gets the parent object for the worksheet.
Gets a Worksheet that represents the previous sheet.
(Inherited from RemoteComponent.)
Gets a value that indicates whether the contents of the worksheet (the individual cells) are protected.
Gets a value that indicates whether shapes are protected.
Gets a Protection object that represents the protection options of the worksheet.
Gets a value that indicates whether user interface-only protection is turned on.
Gets a value that indicates whether worksheet scenarios are protected.
Gets the QueryTables collection that represents all the query tables on the worksheet.
Gets a Range object that represents a cell or a range of cells.
Gets a Range object that represents one or more rows on the worksheet.
Gets the Scripts collection, which contains Script objects representing blocks of script or code in the worksheet when it is saved as a Web page.
Gets or sets the range where scrolling is allowed, as an A1-style range reference.
Gets a Shapes object that represents all the shapes on the worksheet.
(Inherited from RemoteComponent.)
Gets a SmartTags object representing the collection of smart tags for the worksheet.
Gets the sorted values in the current worksheet.
Gets the standard (default) height of all the rows in the worksheet, in points.
Gets or sets the standard (default) width of all the columns in the worksheet.
Gets a Tab for the worksheet.
(Inherited from RemoteComponent.)
Gets or sets a value that indicates whether Microsoft Office Excel uses Lotus 1-2-3 expression evaluation rules for the worksheet.
Gets or sets a value that indicates whether Microsoft Office Excel uses Lotus 1-2-3 formula entry rules for the worksheet.
Gets the worksheet type.
Gets a Range object that represents all the cells that have contained a value at any time.
Gets or sets a XlSheetVisibility value that determines whether the object is visible.
Gets a VPageBreaks collection that represents the vertical page breaks on the sheet.
Top
Events
Name
Description
.gif "Public event")
Occurs when the worksheet is activated.
Occurs when the worksheet is double-clicked, before the default double-click action.
Occurs when the worksheet is right-clicked, before the default right-click action.
(Inherited from EntryPointBindableComponentBase.)
Occurs after the worksheet is recalculated.
Occurs when something changes in the Worksheet cells.
Occurs when the worksheet loses focus.
(Inherited from RemoteComponent.)
Occurs when you click any hyperlink on a worksheet.
Occurs after a PivotTable report is updated on a worksheet.
Occurs when the selection changes on a worksheet.
Occurs when the worksheet host item shuts down.
Occurs after the worksheet is running and all the initialization code in the assembly has been run.
Top
Explicit Interface Implementations
Name
Description
.gif "Explicit interface implemetation")
.gif "Private method")
IEntryPoint.FinishInitialization
(Inherited from EntryPointComponentBase.)
(Inherited from EntryPointComponentBase.)
ISupportInitializeControl.InitializeControl
Infrastructure.
IEntryPoint.InitializeDataBindings
(Inherited from EntryPointComponentBase.)
(Inherited from EntryPointComponentBase.)
Top