WorksheetBase Methods

 

Namespace:   Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

NameDescription
System_CAPS_pubmethodActivate()

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubmethodBeginInit()

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubmethodCalculateMethod()

Calculates the formulas in the worksheet.

System_CAPS_pubmethodChartObjects(Object)

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.

System_CAPS_pubmethodCheckSpelling(Object, Object, Object, Object)

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubmethodCircleInvalid()

Circles invalid entries on the worksheet.

System_CAPS_pubmethodClearArrows()

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

System_CAPS_pubmethodClearCircles()

Clears circles from invalid entries on the worksheet.

System_CAPS_pubmethodCopy(Object, Object)

Copies the worksheet to another location in the workbook.

System_CAPS_pubmethodDelete()

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.

System_CAPS_pubmethodDispose()

Releases all resources used by the current instance of the WorksheetBase class.

System_CAPS_pubmethodEndInit()

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_pubmethodEvaluate(Object)

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

System_CAPS_pubmethodExportAsFixedFormat(XlFixedFormatType, Object, Object, Object, Object, Object, Object, Object, Object)

Exports to a file of the specified format.

System_CAPS_protmethodFinalize()

(Inherited from Object.)

System_CAPS_protmethodFinishInitialization()

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_protmethodGetAutomationObject()

Called by the Visual Studio Tools for Office runtime to get an object that can be used by VBA code in the worksheet.

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_protmethodInitialize()

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_protmethodInitializeDataBindings()

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_protmethodMemberwiseClone()

(Inherited from Object.)

System_CAPS_pubmethodMove(Object, Object)

Moves the worksheet to another location in the workbook.

System_CAPS_pubmethodOLEObjects(Object)

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.

System_CAPS_protmethodOnShutdown()

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_protmethodOnStartup()

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubmethodPaste(Object, Object)

Pastes the contents of the Clipboard onto the worksheet.

System_CAPS_pubmethodPasteSpecial(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.

System_CAPS_pubmethodPivotTables(Object)

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.

System_CAPS_pubmethodPivotTableWizard(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)
System_CAPS_pubmethodPrintOutEx(Object, Object, Object, Object, Object, Object, Object, Object, Object)

Prints the worksheet.

System_CAPS_pubmethodPrintPreview(Object)

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

System_CAPS_pubmethodProtect(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.

System_CAPS_pubmethodResetAllPageBreaks()

Resets all page breaks on the specified worksheet.

System_CAPS_pubmethodSaveAs(String, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Saves changes to the worksheet in a different file.

System_CAPS_pubmethodScenarios(Object)

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.

System_CAPS_pubmethodSelect(Object)

Selects the worksheet.

System_CAPS_pubmethodSetBackgroundPicture(String)

Sets the background graphic for the worksheet.

System_CAPS_pubmethodShowAllData()

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

System_CAPS_pubmethodShowDataForm()

Displays the data form associated with the worksheet.

System_CAPS_pubmethodToString()

(Inherited from Object.)

System_CAPS_pubmethodUnprotect(Object)

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

System_CAPS_pubmethodXmlDataQuery(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.

System_CAPS_pubmethodXmlMapQuery(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.

NameDescription
System_CAPS_pubinterfaceSystem_CAPS_privmethodEntryPoint.BeginInit()

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceSystem_CAPS_privmethodEntryPoint.EndInit()

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceSystem_CAPS_privmethodEntryPoint.FinishInitialization()

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceSystem_CAPS_privmethodEntryPoint.Initialize()

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceSystem_CAPS_privmethodEntryPoint.InitializeDataBindings()

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceSystem_CAPS_privmethodEntryPoint.OnShutdown()

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceSystem_CAPS_privmethodEntryPoint.OnStartup()

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceSystem_CAPS_privmethodIWorksheetExtension.GetAutomationObject()

This API supports the product infrastructure and is not intended to be used directly from your code.

Return to top
Show: