Worksheet Interface

Definition

Represents a worksheet in Excel projects created by using the Office development tools in Visual Studio.

[System.Runtime.InteropServices.Guid("297dc8d9-eabd-45a1-bdef-68ab67e5c3c3")]
[System.Runtime.InteropServices.TypeIdentifier]
public interface Worksheet : IDisposable, System.ComponentModel.IComponent, System.ComponentModel.ISupportInitialize, System.Windows.Forms.IBindableComponent
Attributes
Implements

Remarks

A Microsoft.Office.Tools.Excel.Worksheet object provides the same members as a Microsoft.Office.Interop.Excel.Worksheet object from the Excel primary interop assembly, but it adds the following features:

In application-level projects, you can create Microsoft.Office.Tools.Excel.Worksheet objects programmatically by using the GetVstoObject method. For more information, see Extending Word Documents and Excel Workbooks in VSTO Add-ins at Run Time.

In document-level projects, you typically do not use Microsoft.Office.Tools.Excel.Worksheet object directly. Instead, use the Sheetn classes to programmatically access the worksheets in your project. Each Sheetn class derives most of its members from the Microsoft.Office.Tools.Excel.WorksheetBase class. This class redirects all calls to its members to an internal implementation of the Microsoft.Office.Tools.Excel.Worksheet interface in the Visual Studio Tools for Office runtime. For more information, see Programming Document-Level Customizations.

Note

This interface is implemented by the Visual Studio Tools for Office runtime. It is not intended to be implemented in your code. For more information, see Visual Studio Tools for Office Runtime Overview.

Usage

This documentation describes the version of this type that is used in Office projects that target the .NET Framework 4 or later. In projects that target the .NET Framework 3.5, this type might have different members and the code examples provided for this type might not work. For documentation about this type in projects that target the .NET Framework 3.5, see the following reference section in the Visual Studio 2008 documentation: http://go.microsoft.com/fwlink/?LinkId=160658.

Properties

_CodeName
_DisplayRightToLeft
Application

This property gets a Application that represents the Microsoft Office Excel application.

AutoFilter

Gets a AutoFilter that provides information about filtered lists on the worksheet if filtering is enabled. Gets null if filtering is off.

AutoFilterMode

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).

Cells

Gets a Range object that represents all the cells on the worksheet (not just the cells that are currently in use).

CircularReference

Gets a Range object that represents the range containing the first circular reference on the sheet, or gets null if there is no circular reference on the sheet.

CodeName
Columns

Gets a Range object that represents one or more columns on the worksheet.

Comments

Gets a Comments collection that represents all the comments for the worksheet.

ConsolidationFunction

Gets the function code used for the current consolidation.

ConsolidationOptions

Gets a three-element Array of consolidation options.

ConsolidationSources

Gets an Array of strings that name the source sheets and ranges for the worksheet's current consolidation.

Controls

Gets the collection of managed controls that are contained on the worksheet.

Creator

Gets a value that indicates the application in which the worksheet was created.

CustomProperties

Gets a CustomProperties object representing the identifier information associated with a worksheet.

DataHost
DefaultExtension

Gets the default extension for this Worksheet object.

DisplayAutomaticPageBreaks
DisplayPageBreaks

Gets or sets a value that indicates whether page breaks (both automatic and manual) on the worksheet are displayed.

DisplayRightToLeft

Gets or sets a value that indicates whether the worksheet is displayed from right to left instead of from left to right.

EnableAutoFilter

Gets or sets a value that indicates whether AutoFilter arrows are enabled when user-interface-only protection is turned on.

EnableCalculation

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.

EnableOutlining

Gets or sets a value that indicates whether outlining symbols are enabled when user-interface-only protection is turned on.

EnablePivotTable

Gets or sets a value that indicates whether PivotTable controls and actions are enabled when user-interface-only protection is turned on.

EnableSelection

Gets or sets a value indicating which cells can be selected on the sheet.

Extension

Gets a custom extension for this Worksheet object.

FilterMode

Gets a value that indicates whether the worksheet is actively filtering data.

HostContext
HPageBreaks

Gets an HPageBreaks collection that represents the horizontal page breaks on the sheet.

Hyperlinks

Gets a Hyperlinks collection that represents the hyperlinks for the range or worksheet.

Index

Gets the index number of the worksheet within the collection of worksheets.

InnerObject

Gets a Worksheet that represents the underlying native object for the Worksheet.

ItemProvider
ListObjects

Gets a collection of ListObject objects in the worksheet.

MailEnvelope

Gets an e-mail header for the worksheet.

Name

Gets or sets the name of the worksheet.

Names

Gets a Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix).

Next

Gets a Worksheet that represents the next sheet.

OnCalculate
OnData
OnDoubleClick
OnEntry
OnSheetActivate
OnSheetDeactivate
Outline

Gets an Outline that represents the outline for the worksheet.

PageSetup

Gets a PageSetup that contains all the page setup settings for the worksheet.

Parent

Gets the parent object for the worksheet.

Previous

Gets a Worksheet that represents the previous sheet.

PrintedCommentPages

Gets the number of comment pages that will be printed for the current worksheet.

ProtectContents

Gets a value that indicates whether the contents of the worksheet (the individual cells) are protected.

ProtectDrawingObjects

Gets a value that indicates whether shapes are protected.

Protection

Gets a Protection object that represents the protection options of the worksheet.

ProtectionMode

Gets a value that indicates whether user interface-only protection is turned on.

ProtectScenarios

Gets a value that indicates whether worksheet scenarios are protected.

QueryTables

Gets the QueryTables collection that represents all the query tables on the worksheet.

Range

Gets a Range object that represents a cell or a range of cells.

Rows

Gets a Range object that represents one or more rows on the worksheet.

Scripts
ScrollArea

Gets or sets the range where scrolling is allowed, as an A1-style range reference.

Shapes

Gets a Shapes object that represents all the shapes on the worksheet.

SmartTags
Sort

Gets the sorted values in the current worksheet.

StandardHeight

Gets the standard (default) height of all the rows in the worksheet, in points.

StandardWidth

Gets or sets the standard (default) width of all the columns in the worksheet.

Tab

Gets a Tab for the worksheet.

Tag

Gets or sets the object that contains data about the worksheet.

TransitionExpEval

Gets or sets a value that indicates whether Microsoft Office Excel uses Lotus 1-2-3 expression evaluation rules for the worksheet.

TransitionFormEntry

Gets or sets a value that indicates whether Microsoft Office Excel uses Lotus 1-2-3 formula entry rules for the worksheet.

Type

Gets the worksheet type.

UsedRange

Gets a Range object that represents all the cells that have contained a value at any time.

Visible

Gets or sets a XlSheetVisibility value that determines whether the object is visible.

VPageBreaks

Gets a VPageBreaks collection that represents the vertical page breaks on the sheet.

Methods

_VtblGap1_1()
_VtblGap2_1()
_VtblGap3_1()
_VtblGap4_1()
_VtblGap5_1()
_VtblGap6_1()
_VtblGap7_1()
Activate()

Makes the current sheet the active sheet.

Arcs(Object)
Buttons(Object)
CalculateMethod()

Calculates the formulas in the worksheet.

ChartObjects(Object)

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.

CheckBoxes(Object)
CheckSpelling(Object, Object, Object, Object)

Checks the spelling in a worksheet.

CircleInvalid()

Circles invalid entries on the worksheet.

ClearArrows()

Clears the tracer arrows from the worksheet. Tracer arrows are added by using the auditing feature.

ClearCircles()

Clears circles from invalid entries on the worksheet.

Copy(Object, Object)

Copies the worksheet to another location in the workbook.

Delete()

Deletes the underlying Worksheet object, but does not delete the host item. It is highly recommended that this method not be used.

DrawingObjects(Object)
Drawings(Object)
DropDowns(Object)
Evaluate(Object)

Converts a Microsoft Office Excel name to an object or a value.

ExportAsFixedFormat(XlFixedFormatType, Object, Object, Object, Object, Object, Object, Object, Object)

Exports to a file of the specified format.

GroupBoxes(Object)
GroupObjects(Object)
Labels(Object)
Lines(Object)
ListBoxes(Object)
Move(Object, Object)

Moves the worksheet to another location in the workbook.

OLEObjects(Object)

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.

OptionButtons(Object)
Ovals(Object)
Paste(Object, Object)

Pastes the contents of the Clipboard onto the worksheet.

PasteSpecial(Object, Object, Object, Object, Object, Object, Object)

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.

Pictures(Object)
PivotTables(Object)

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.

PivotTableWizard(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Creates a PivotTable object.

PrintOut(Object, Object, Object, Object, Object, Object, Object, Object)
PrintOutEx(Object, Object, Object, Object, Object, Object, Object, Object, Object)

Prints the worksheet.

PrintPreview(Object)

Shows a preview of the worksheet as it would look when printed.

Protect(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Protects a worksheet so that it cannot be modified.

Rectangles(Object)
ResetAllPageBreaks()

Resets all page breaks on the specified worksheet.

SaveAs(String, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Saves changes to the worksheet in a different file.

Scenarios(Object)

Gets an object that represents either a single scenario (a Scenario object) or a collection of scenarios (a Scenarios object) on the worksheet.

ScrollBars(Object)
Select(Object)

Selects the worksheet.

SetBackgroundPicture(String)

Sets the background graphic for the worksheet.

ShowAllData()

Makes all rows of the currently filtered list visible. If AutoFilter is in use, this method changes the arrows to "All."

ShowDataForm()

Displays the data form associated with the worksheet.

Spinners(Object)
TextBoxes(Object)
Unprotect(Object)

Removes protection from the worksheet. This method has no effect if the worksheet is not protected.

XmlDataQuery(String, Object, Object)

Gets a Range object that represents the cells mapped to a particular XPath. Gets null if the specified XPath has not been mapped to the worksheet, or if the mapped range is empty.

XmlMapQuery(String, Object, Object)

Gets a Range object that represents the cells mapped to a particular XPath. Gets null if the specified XPath has not been mapped to the worksheet.

Events

ActivateEvent

Occurs when the worksheet is activated.

BeforeDoubleClick

Occurs when the worksheet is double-clicked, before the default double-click action.

BeforeRightClick

Occurs when the worksheet is right-clicked, before the default right-click action.

BindingContextChanged
Calculate

Occurs after the worksheet is recalculated.

Change

Occurs when something changes in the Worksheet cells.

Deactivate

Occurs when the worksheet loses focus.

FollowHyperlink

Occurs when you click any hyperlink on a worksheet.

PivotTableAfterValueChange

Occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).

PivotTableBeforeAllocateChanges

Occurs before changes are applied to a PivotTable.

PivotTableBeforeCommitChanges

Occurs before changes are committed against the OLAP data source for a PivotTable.

PivotTableBeforeDiscardChanges

Occurs before changes to a PivotTable are discarded.

PivotTableChangeSync

Occurs after changes to a PivotTable.

PivotTableUpdate

Occurs after a PivotTable report is updated on a worksheet.

SelectionChange

Occurs when the selection changes on a worksheet.

Shutdown

Occurs when the worksheet host item shuts down.

Startup

Occurs after the worksheet is running and all the initialization code in the assembly has been run.

Applies to