WorksheetClass Class

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Reserved for internal use.

public ref class WorksheetClass : Microsoft::Office::Interop::Excel::Worksheet

[System.Runtime.InteropServices.ClassInterface(0)]
[System.Runtime.InteropServices.Guid("00020820-0000-0000-C000-000000000046")]
public class WorksheetClass : Microsoft.Office.Interop.Excel.Worksheet

Public Class WorksheetClass
Implements Worksheet

Inheritance: Object
WorksheetClass

Attributes: ClassInterfaceAttribute GuidAttribute

Implements: Worksheet

Constructors

WorksheetClass()

Properties

_CodeName
_DisplayRightToLeft
Application
AutoFilter
AutoFilterMode
Cells
CircularReference
CodeName
Columns
Comments
ConsolidationFunction
ConsolidationOptions
ConsolidationSources
Creator
CustomProperties
DisplayAutomaticPageBreaks
DisplayPageBreaks
DisplayRightToLeft
EnableAutoFilter
EnableCalculation
EnableFormatConditionsCalculation
EnableOutlining
EnablePivotTable
EnableSelection
FilterMode
HPageBreaks
Hyperlinks
Index
ListObjects
MailEnvelope
Name
Names
Next
OnCalculate
OnData
OnDoubleClick
OnEntry
OnSheetActivate
OnSheetDeactivate
Outline
PageSetup
Parent
Previous
PrintedCommentPages
ProtectContents
ProtectDrawingObjects
Protection
ProtectionMode
ProtectScenarios
QueryTables
Range[Object, Object]
Rows
Scripts
ScrollArea
Shapes
SmartTags
Sort
StandardHeight
StandardWidth
Tab
TransitionExpEval
TransitionFormEntry
Type
UsedRange
Visible
VPageBreaks

Methods

_CheckSpelling(Object, Object, Object, Object, Object, Object)
_Evaluate(Object)
_PasteSpecial(Object, Object, Object, Object, Object, Object)
_PrintOut(Object, Object, Object, Object, Object, Object, Object)
_Protect(Object, Object, Object, Object, Object)
_SaveAs(String, Object, Object, Object, Object, Object, Object, Object, Object)
Activate()
Arcs(Object)
Buttons(Object)
Calculate()
ChartObjects(Object)
CheckBoxes(Object)
CheckSpelling(Object, Object, Object, Object)
CircleInvalid()
ClearArrows()
ClearCircles()
Copy(Object, Object)
Delete()
DrawingObjects(Object)
Drawings(Object)
DropDowns(Object)
Evaluate(Object)
ExportAsFixedFormat(XlFixedFormatType, Object, Object, Object, Object, Object, Object, Object, Object)
GroupBoxes(Object)
GroupObjects(Object)
Labels(Object)
Lines(Object)
ListBoxes(Object)
Move(Object, Object)
OLEObjects(Object)
OptionButtons(Object)
Ovals(Object)
Paste(Object, Object)
PasteSpecial(Object, Object, Object, Object, Object, Object, Object)
Pictures(Object)
PivotTables(Object)
PivotTableWizard(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)
PrintOut(Object, Object, Object, Object, Object, Object, Object, Object)
PrintOutEx(Object, Object, Object, Object, Object, Object, Object, Object, Object)
PrintPreview(Object)
Protect(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)
Rectangles(Object)
ResetAllPageBreaks()
SaveAs(String, Object, Object, Object, Object, Object, Object, Object, Object, Object)
Scenarios(Object)
ScrollBars(Object)
Select(Object)
SetBackgroundPicture(String)
ShowAllData()
ShowDataForm()
Spinners(Object)
TextBoxes(Object)
Unprotect(Object)
XmlDataQuery(String, Object, Object)
XmlMapQuery(String, Object, Object)

Events

BeforeDelete
BeforeDoubleClick
BeforeRightClick
Change
Deactivate
DocEvents_Event_Activate
DocEvents_Event_Calculate
FollowHyperlink
LensGalleryRenderComplete
PivotTableAfterValueChange
PivotTableBeforeAllocateChanges
PivotTableBeforeCommitChanges
PivotTableBeforeDiscardChanges
PivotTableChangeSync
PivotTableUpdate
SelectionChange
TableUpdate

Applies to

共用方式為