Worksheet Methods
Include Protected Members
Include Inherited Members
The Worksheet type exposes the following members.
Methods
Name | Description | |
---|---|---|
_CheckSpelling | Infrastructure. | |
_Evaluate | Infrastructure. | |
_PasteSpecial | Infrastructure. | |
_PrintOut | Infrastructure. | |
_Protect | Infrastructure. | |
_SaveAs | Infrastructure. | |
_VtblGap1_1 | Infrastructure. | |
_VtblGap2_1 | Infrastructure. | |
_VtblGap3_1 | Infrastructure. | |
_VtblGap4_1 | Infrastructure. | |
_VtblGap5_1 | Infrastructure. | |
_VtblGap6_1 | Infrastructure. | |
_VtblGap7_1 | Infrastructure. | |
Activate | Makes the current sheet the active sheet. | |
Arcs | Infrastructure. | |
BeginInit | Signals the object that initialization is starting. (Inherited from ISupportInitialize.) | |
Buttons | Infrastructure. | |
CalculateMethod | Calculates the formulas in the worksheet. | |
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. | |
CheckBoxes | Infrastructure. | |
CheckSpelling | 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 | Copies the worksheet to another location in the workbook. | |
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. | |
Dispose | Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. (Inherited from IDisposable.) | |
DrawingObjects | Infrastructure. | |
Drawings | Infrastructure. | |
DropDowns | Infrastructure. | |
EndInit | Signals the object that initialization is complete. (Inherited from ISupportInitialize.) | |
Evaluate | Converts a Microsoft Office Excel name to an object or a value. | |
ExportAsFixedFormat | Exports to a file of the specified format. | |
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. | |
GroupBoxes | Infrastructure. | |
GroupObjects | Infrastructure. | |
Labels | Infrastructure. | |
Lines | Infrastructure. | |
ListBoxes | Infrastructure. | |
Move | Moves the worksheet to another location in the workbook. | |
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. | |
OptionButtons | Infrastructure. | |
Ovals | Infrastructure. | |
Paste | Pastes the contents of the Clipboard onto the worksheet. | |
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. | |
Pictures | Infrastructure. | |
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. | |
PivotTableWizard | Creates a Microsoft.Office.Interop.Excel.PivotTable object. | |
PrintOut | Prints the worksheet. | |
PrintOutEx | Prints the worksheet. | |
PrintPreview | Shows a preview of the worksheet as it would look when printed. | |
Protect | Protects a worksheet so that it cannot be modified. | |
Rectangles | Infrastructure. | |
ResetAllPageBreaks | Resets all page breaks on the specified worksheet. | |
SaveAs | Saves changes to the worksheet in a different file. | |
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. | |
ScrollBars | Infrastructure. | |
Select | Selects the worksheet. | |
SetBackgroundPicture | 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 | Infrastructure. | |
TextBoxes | Infrastructure. | |
Unprotect | Removes protection from the worksheet. This method has no effect if the worksheet is not protected. | |
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. | |
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