Worksheet Methods

  • Article

Include Protected Members
Include Inherited Members

The Worksheet type exposes the following members.

Methods

  Name Description
Public method _CheckSpelling Infrastructure.
Public method _Evaluate Infrastructure.
Public method _PasteSpecial Infrastructure.
Public method _PrintOut Infrastructure.
Public method _Protect Infrastructure.
Public method _SaveAs Infrastructure.
Public method _VtblGap1_1
Public method _VtblGap2_1
Public method _VtblGap3_1
Public method _VtblGap4_1
Public method _VtblGap5_1
Public method _VtblGap6_1
Public method _VtblGap7_1
Public method Activate Makes the current sheet the active sheet.
Public method Arcs Infrastructure.
Public method BeginInit Signals the object that initialization is starting. (Inherited from ISupportInitialize.)
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 ChartObject) or a collection of all the embedded charts (a ChartObjects) on the worksheet.
Public method CheckBoxes Infrastructure.
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 Delete Deletes the underlying Worksheet object, but does not delete the host item. It is highly recommended that this method not be used.
Public method Dispose Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. (Inherited from IDisposable.)
Public method DrawingObjects Infrastructure.
Public method Drawings Infrastructure.
Public method DropDowns Infrastructure.
Public method EndInit Signals the object that initialization is complete. (Inherited from ISupportInitialize.)
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.
Public method get_Range Gets a Range object that represents a cell or a range of cells. Use the Range property instead of this method.
Public method GroupBoxes Infrastructure.
Public method GroupObjects Infrastructure.
Public method Labels Infrastructure.
Public method Lines Infrastructure.
Public method ListBoxes Infrastructure.
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 OLEObject) or a collection of all OLE objects (an OLEObjects collection) on the worksheet.
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 PivotTable object) or a collection of all the PivotTable reports (a PivotTables object) on a worksheet.
Public method PivotTableWizard Creates a 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 Scenario object) or a collection of scenarios (a 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 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 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.
Public method XmlMapQuery 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

See Also

Reference

Worksheet Interface

Microsoft.Office.Tools.Excel Namespace