WorksheetBase Properties
Include Protected Members
Include Inherited Members
The WorksheetBase type exposes the following members.
Properties
Name | Description | |
---|---|---|
_CodeName | Infrastructure. | |
_DisplayRightToLeft | Infrastructure. | |
Application | Gets a Microsoft.Office.Interop.Excel.Application object that represents the Microsoft Office Excel application. | |
AutoFilter | Gets a Microsoft.Office.Interop.Excel.AutoFilter that provides information about filtered lists on the worksheet if filtering is enabled. Gets nulla null reference (Nothing in Visual Basic) if filtering is off. | |
AutoFilterMode | Gets or sets a value that indicates whether filtering is currently enabled on the worksheet (that is, whether the filter drop-down arrows are currently displayed). | |
Base | Gets the Worksheet object that this WorksheetBase object extends. | |
BindingContext | Infrastructure. | |
Cells | Gets a Range object that represents all the cells on the worksheet (not just the cells that are currently in use). | |
CircularReference | Gets a Range object that represents the range containing the first circular reference on the sheet, or gets nulla null reference (Nothing in Visual Basic) if there is no circular reference on the sheet. | |
CodeName | Infrastructure. | |
Columns | Gets a Range object that represents one or more columns on the worksheet. | |
Comments | Gets a Microsoft.Office.Interop.Excel.Comments collection that represents all the comments for the worksheet. | |
ConsolidationFunction | Gets the function code used for the current consolidation. | |
ConsolidationOptions | Gets a three-element Array of consolidation options. | |
ConsolidationSources | Gets an Array of strings that name the source sheets and ranges for the worksheet's current consolidation. | |
Controls | Gets the collection of managed controls that are contained on the worksheet. | |
Creator | Gets a value that indicates the application in which the worksheet was created. | |
CustomProperties | Gets a Microsoft.Office.Interop.Excel.CustomProperties object representing the identifier information associated with a worksheet. | |
DataBindings | Infrastructure. | |
DataHost | Infrastructure. | |
DisplayAutomaticPageBreaks | Infrastructure. | |
DisplayPageBreaks | Gets or sets a value that indicates whether page breaks (both automatic and manual) on the worksheet are displayed. | |
DisplayRightToLeft | Gets or sets a value that indicates whether the worksheet is displayed from right to left instead of from left to right. | |
EnableAutoFilter | Gets or sets a value that indicates whether AutoFilter arrows are enabled when user-interface-only protection is turned on. | |
EnableCalculation | Gets or set a value that indicates whether Microsoft Office Excel automatically recalculates the worksheet when necessary. | |
EnableFormatConditionsCalculation | Gets or sets a value that determines whether conditional formats will occur automatically. | |
EnableOutlining | Gets or sets a value that indicates whether outlining symbols are enabled when user-interface-only protection is turned on. This type or member is intended to be used only in projects for the 2007 Microsoft Office system. Smart tags are deprecated in Office 2010. . This type or member is intended to be used only in projects for the 2007 Microsoft Office system. Smart tags are deprecated in Office 2010. . |
|
EnablePivotTable | Gets or sets a value that indicates whether PivotTable controls and actions are enabled when user-interface-only protection is turned on. | |
EnableSelection | Gets or sets a value indicating which cells can be selected on the sheet. | |
FilterMode | Gets a value that indicates whether the worksheet is actively filtering data. | |
HostContext | Infrastructure. | |
HPageBreaks | Gets an Microsoft.Office.Interop.Excel.HPageBreaks collection that represents the horizontal page breaks on the sheet. | |
Hyperlinks | Gets a Microsoft.Office.Interop.Excel.Hyperlinks collection that represents the hyperlinks for the range or worksheet. | |
Index | Gets the index number of the worksheet within the collection of worksheets. | |
InnerObject | Gets a Microsoft.Office.Interop.Excel.Worksheet that represents the underlying native object for the WorksheetBase. | |
ItemProvider | Infrastructure. | |
ListObjects | Gets a collection of Microsoft.Office.Interop.Excel.ListObject objects in the worksheet. | |
MailEnvelope | Gets an e-mail header for the worksheet. | |
Name | Gets or sets the name of the worksheet. | |
Names | Gets a Microsoft.Office.Interop.Excel.Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix). | |
Next | Gets a Microsoft.Office.Interop.Excel.Worksheet that represents the next sheet. | |
OnCalculate | Infrastructure. | |
OnData | Infrastructure. | |
OnDoubleClick | Infrastructure. | |
OnEntry | Infrastructure. | |
OnSheetActivate | Infrastructure. | |
OnSheetDeactivate | Infrastructure. | |
Outline | Gets an Microsoft.Office.Interop.Excel.Outline that represents the outline for the worksheet. | |
PageSetup | Gets a Microsoft.Office.Interop.Excel.PageSetup that contains all the page setup settings for the worksheet. | |
Parent | Gets the parent object for the worksheet. | |
Previous | Gets a Microsoft.Office.Interop.Excel.Worksheet that represents the previous sheet. | |
PrintedCommentPages | Gets the number of comment pages that will be printed for the current worksheet. This property can be used only in Excel 2010 projects. | |
ProtectContents | Gets a value that indicates whether the contents of the worksheet (the individual cells) are protected. | |
ProtectDrawingObjects | Gets a value that indicates whether shapes are protected. | |
Protection | Gets a Microsoft.Office.Interop.Excel.Protection object that represents the protection options of the worksheet. | |
ProtectionMode | Gets a value that indicates whether user interface-only protection is turned on. | |
ProtectScenarios | Gets a value that indicates whether worksheet scenarios are protected. | |
QueryTables | Gets the Microsoft.Office.Interop.Excel.QueryTables collection that represents all the query tables on the worksheet. | |
Range | Gets a Microsoft.Office.Interop.Excel.Range object that represents a cell or a range of cells. | |
Rows | Gets a Range object that represents one or more rows on the worksheet. | |
Scripts | Gets the Microsoft.Office.Core.Scripts collection, which contains Script objects representing blocks of script or code in the worksheet when it is saved as a Web page. | |
ScrollArea | Gets or sets the range where scrolling is allowed, as an A1-style range reference. | |
Shapes | Gets a Microsoft.Office.Interop.Excel.Shapes object that represents all the shapes on the worksheet. | |
Site | Infrastructure. | |
SmartTags | Gets a Microsoft.Office.Interop.Excel.SmartTags object representing the collection of smart tags for the worksheet. | |
Sort | Gets the sorted values in the current worksheet. | |
StandardHeight | Gets the standard (default) height of all the rows in the worksheet, in points. | |
StandardWidth | Gets or sets the standard (default) width of all the columns in the worksheet. | |
Tab | Gets a Microsoft.Office.Interop.Excel.Tab for the worksheet. | |
Tag | Gets or sets the object that contains data about the worksheet. | |
TransitionExpEval | Gets or sets a value that indicates whether Microsoft Office Excel uses Lotus 1-2-3 expression evaluation rules for the worksheet. | |
TransitionFormEntry | Gets or sets a value that indicates whether Microsoft Office Excel uses Lotus 1-2-3 formula entry rules for the worksheet. | |
Type | Gets the worksheet type. | |
UsedRange | Gets a Microsoft.Office.Interop.Excel.Range object that represents all the cells that have contained a value at any time. | |
Visible | Gets or sets a Microsoft.Office.Interop.Excel.XlSheetVisibility value that determines whether the object is visible. | |
VPageBreaks | Gets a Microsoft.Office.Interop.Excel.VPageBreaks collection that represents the vertical page breaks on the sheet. |
Top
Explicit Interface Implementations
Name | Description | |
---|---|---|
IExtension.ExtensionBase | Infrastructure. |
Top