WorksheetBase Properties

 

Namespace:   Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

NameDescription
System_CAPS_pubpropertyApplication

Gets a Microsoft.Office.Interop.Excel.Application object that represents the Microsoft Office Excel application.

System_CAPS_pubpropertyAutoFilter

Gets a Microsoft.Office.Interop.Excel.AutoFilter that provides information about filtered lists on the worksheet if filtering is enabled. Gets null if filtering is off.

System_CAPS_pubpropertyAutoFilterMode

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).

System_CAPS_pubpropertyBase

Gets the Worksheet object that this WorksheetBase object extends.

System_CAPS_pubpropertyBindingContext

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubpropertyCells

Gets a Range object that represents all the cells on the worksheet (not just the cells that are currently in use).

System_CAPS_pubpropertyCircularReference

Gets a Range object that represents the range containing the first circular reference on the sheet, or gets null if there is no circular reference on the sheet.

System_CAPS_pubpropertyColumns

Gets a Range object that represents one or more columns on the worksheet.

System_CAPS_pubpropertyComments

Gets a Microsoft.Office.Interop.Excel.Comments collection that represents all the comments for the worksheet.

System_CAPS_pubpropertyConsolidationFunction

Gets the function code used for the current consolidation.

System_CAPS_pubpropertyConsolidationOptions

Gets a three-element Array of consolidation options.

System_CAPS_pubpropertyConsolidationSources

Gets an Array of strings that name the source sheets and ranges for the worksheet's current consolidation.

System_CAPS_pubpropertyControls

Gets the collection of managed controls that are contained on the worksheet.

System_CAPS_pubpropertyCreator

Gets a value that indicates the application in which the worksheet was created.

System_CAPS_pubpropertyCustomProperties

Gets a Microsoft.Office.Interop.Excel.CustomProperties object representing the identifier information associated with a worksheet.

System_CAPS_pubpropertyDataBindings

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubpropertyDataHost

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubpropertyDisplayPageBreaks

Gets or sets a value that indicates whether page breaks (both automatic and manual) on the worksheet are displayed.

System_CAPS_pubpropertyDisplayRightToLeft

Gets or sets a value that indicates whether the worksheet is displayed from right to left instead of from left to right.

System_CAPS_pubpropertyEnableAutoFilter

Gets or sets a value that indicates whether AutoFilter arrows are enabled when user-interface-only protection is turned on.

System_CAPS_pubpropertyEnableCalculation

Gets or set a value that indicates whether Microsoft Office Excel automatically recalculates the worksheet when necessary.

System_CAPS_pubpropertyEnableFormatConditionsCalculation

Gets or sets a value that determines whether conditional formats will occur automatically.

System_CAPS_pubpropertyEnableOutlining

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.

.

System_CAPS_pubpropertyEnablePivotTable

Gets or sets a value that indicates whether PivotTable controls and actions are enabled when user-interface-only protection is turned on.

System_CAPS_pubpropertyEnableSelection

Gets or sets a value indicating which cells can be selected on the sheet.

System_CAPS_pubpropertyFilterMode

Gets a value that indicates whether the worksheet is actively filtering data.

System_CAPS_pubpropertyHostContext

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubpropertyHPageBreaks

Gets an Microsoft.Office.Interop.Excel.HPageBreaks collection that represents the horizontal page breaks on the sheet.

System_CAPS_pubpropertyHyperlinks

Gets a Microsoft.Office.Interop.Excel.Hyperlinks collection that represents the hyperlinks for the range or worksheet.

System_CAPS_pubpropertyIndex

Gets the index number of the worksheet within the collection of worksheets.

System_CAPS_pubpropertyInnerObject

Gets a Microsoft.Office.Interop.Excel.Worksheet that represents the underlying native object for the WorksheetBase.

System_CAPS_pubpropertyItemProvider

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubpropertyListObjects

Gets a collection of Microsoft.Office.Interop.Excel.ListObject objects in the worksheet.

System_CAPS_pubpropertyMailEnvelope

Gets an e-mail header for the worksheet.

System_CAPS_pubpropertyName

Gets or sets the name of the worksheet.

System_CAPS_pubpropertyNames

Gets a Microsoft.Office.Interop.Excel.Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix).

System_CAPS_pubpropertyNext

Gets a Microsoft.Office.Interop.Excel.Worksheet that represents the next sheet.

System_CAPS_pubpropertyOutline

Gets an Microsoft.Office.Interop.Excel.Outline that represents the outline for the worksheet.

System_CAPS_pubpropertyPageSetup

Gets a Microsoft.Office.Interop.Excel.PageSetup that contains all the page setup settings for the worksheet.

System_CAPS_pubpropertyParent

Gets the parent object for the worksheet.

System_CAPS_pubpropertyPrevious

Gets a Microsoft.Office.Interop.Excel.Worksheet that represents the previous sheet.

System_CAPS_pubpropertyPrintedCommentPages

Gets the number of comment pages that will be printed for the current worksheet. This property can be used only in Excel 2010 projects.

System_CAPS_pubpropertyProtectContents

Gets a value that indicates whether the contents of the worksheet (the individual cells) are protected.

System_CAPS_pubpropertyProtectDrawingObjects

Gets a value that indicates whether shapes are protected.

System_CAPS_pubpropertyProtection

Gets a Microsoft.Office.Interop.Excel.Protection object that represents the protection options of the worksheet.

System_CAPS_pubpropertyProtectionMode

Gets a value that indicates whether user interface-only protection is turned on.

System_CAPS_pubpropertyProtectScenarios

Gets a value that indicates whether worksheet scenarios are protected.

System_CAPS_pubpropertyQueryTables

Gets the Microsoft.Office.Interop.Excel.QueryTables collection that represents all the query tables on the worksheet.

System_CAPS_pubpropertyRange

Gets a Microsoft.Office.Interop.Excel.Range object that represents a cell or a range of cells.

System_CAPS_pubpropertyRows

Gets a Range object that represents one or more rows on the worksheet.

System_CAPS_pubpropertyScrollArea

Gets or sets the range where scrolling is allowed, as an A1-style range reference.

System_CAPS_pubpropertyShapes

Gets a Microsoft.Office.Interop.Excel.Shapes object that represents all the shapes on the worksheet.

System_CAPS_pubpropertySite

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubpropertySort

Gets the sorted values in the current worksheet.

System_CAPS_pubpropertyStandardHeight

Gets the standard (default) height of all the rows in the worksheet, in points.

System_CAPS_pubpropertyStandardWidth

Gets or sets the standard (default) width of all the columns in the worksheet.

System_CAPS_pubpropertyTab

Gets a Microsoft.Office.Interop.Excel.Tab for the worksheet.

System_CAPS_pubpropertyTag

Gets or sets the object that contains data about the worksheet.

System_CAPS_pubpropertyTransitionExpEval

Gets or sets a value that indicates whether Microsoft Office Excel uses Lotus 1-2-3 expression evaluation rules for the worksheet.

System_CAPS_pubpropertyTransitionFormEntry

Gets or sets a value that indicates whether Microsoft Office Excel uses Lotus 1-2-3 formula entry rules for the worksheet.

System_CAPS_pubpropertyType

Gets the worksheet type.

System_CAPS_pubpropertyUsedRange

Gets a Microsoft.Office.Interop.Excel.Range object that represents all the cells that have contained a value at any time.

System_CAPS_pubpropertyVisible

Gets or sets a Microsoft.Office.Interop.Excel.XlSheetVisibility value that determines whether the object is visible.

System_CAPS_pubpropertyVPageBreaks

Gets a Microsoft.Office.Interop.Excel.VPageBreaks collection that represents the vertical page breaks on the sheet.

Return to top
Show: