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