Export (0) Print
Expand All
Expand Minimize

WorksheetBase Methods

The WorksheetBase type exposes the following members.

  Name Description
Public method Activate Infrastructure.
Public method Arcs Infrastructure.
Public method BeginInit Infrastructure.
Public method Buttons Infrastructure.
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 Infrastructure.
Public method CheckSpelling Infrastructure.
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 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 Releases all resources used by the current instance of the WorksheetBase class.
Public method DrawingObjects Infrastructure.
Public method Drawings Infrastructure.
Public method DropDowns Infrastructure.
Public method EndInit Infrastructure.
Public method Equals Determines whether the specified object is equal to the current object. (Inherited from Object.)
Public method Evaluate Converts a Microsoft Office Excel name to an object or a value.
Public method ExportAsFixedFormat Exports to a file of the specified format.
Protected method Finalize Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
Protected method FinishInitialization Infrastructure.
Public method get_Range Gets a Microsoft.Office.Interop.Excel.Range object that represents a cell or a range of cells. Use the Range property instead of this method.
Protected method GetAutomationObject Called by the Visual Studio Tools for Office runtime to get an object that can be used by VBA code in the worksheet.
Public method GetHashCode Serves as the default hash function. (Inherited from Object.)
Public method GetType Gets the Type of the current instance. (Inherited from Object.)
Public method GroupBoxes Infrastructure.
Public method GroupObjects Infrastructure.
Protected method Initialize Infrastructure.
Protected method InitializeDataBindings Infrastructure.
Public method Labels Infrastructure.
Public method Lines Infrastructure.
Public method ListBoxes Infrastructure.
Protected method MemberwiseClone Creates a shallow copy of the current Object. (Inherited from Object.)
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.
Protected method OnShutdown Infrastructure.
Protected method OnStartup Infrastructure.
Public method OptionButtons Infrastructure.
Public method Ovals Infrastructure.
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 Infrastructure.
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 PrintOutEx 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 Infrastructure.
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 Infrastructure.
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 Infrastructure.
Public method TextBoxes Infrastructure.
Public method ToString Returns a string that represents the current object. (Inherited from Object.)
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 null 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 null if the specified XPath has not been mapped to the worksheet.
Top
Show:
© 2014 Microsoft