NamedRange Properties

 

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

NameDescription
System_CAPS_pubpropertyAddIndent

Gets or sets a value that determines whether text is automatically indented when the text alignment in the NamedRange control is set to equal distribution either horizontally or vertically.

System_CAPS_pubpropertyAddress

Gets the range reference for the NamedRange control.

System_CAPS_pubpropertyAddressLocal

Gets the range reference for the NamedRange control in the language of the user.

System_CAPS_pubpropertyAllowEdit

Gets a value that indicates whether the NamedRange control can be edited on a protected worksheet.

System_CAPS_pubpropertyApplication

Gets a Microsoft.Office.Interop.Excel.Application that represents the creator of the NamedRange control.

System_CAPS_pubpropertyAreas

Gets an Areas collection that represents all the ranges in a multiple-area selection.

System_CAPS_pubpropertyBindingContext

(Inherited from IBindableComponent.)

System_CAPS_pubpropertyBorders

Gets a Borders collection that represents the borders of the NamedRange control.

System_CAPS_pubpropertyCells

Gets a Microsoft.Office.Interop.Excel.Range that represents the cells in the NamedRange control.

System_CAPS_pubpropertyCharacters

Gets a Microsoft.Office.Interop.Excel.Characters object that represents a range of characters within the text of the NamedRange control.

System_CAPS_pubpropertyColumn

Gets the number of the first column in the first area of the NamedRange control.

System_CAPS_pubpropertyColumns

Gets a Microsoft.Office.Interop.Excel.Range that represents the one or more columns in the NamedRange control.

System_CAPS_pubpropertyColumnWidth

Gets or sets the width of all columns in the NamedRange control.

System_CAPS_pubpropertyComment

Gets a Comment that represents the comment associated with the cell in the upper left corner of the NamedRange control.

System_CAPS_pubpropertyContainer

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

System_CAPS_pubpropertyCount

Gets the number of cells in the NamedRange control.

System_CAPS_pubpropertyCountLarge

Gets the number of occurrences of the largest value in a range of values.

System_CAPS_pubpropertyCreator

Gets a 32-bit integer that indicates the application in which the NamedRange control was created.

System_CAPS_pubpropertyCurrentArray

If the NamedRange control is part of an array, gets a Microsoft.Office.Interop.Excel.Range that represents the entire array.

System_CAPS_pubpropertyCurrentRegion

Gets a Microsoft.Office.Interop.Excel.Range that represents the current region.

System_CAPS_pubpropertyDataBindings

(Inherited from IBindableComponent.)

System_CAPS_pubpropertyDefaultDataSourceUpdateMode

Gets or sets the default DataSourceUpdateMode.

System_CAPS_pubpropertyDependents

Gets a Microsoft.Office.Interop.Excel.Range that represents the range containing all the dependents of the NamedRange control.

System_CAPS_pubpropertyDirectDependents

Gets a Microsoft.Office.Interop.Excel.Range that represents the range containing all the direct dependents of the NamedRange control.

System_CAPS_pubpropertyDirectPrecedents

Gets a Microsoft.Office.Interop.Excel.Range that represents the range containing all the direct precedents of the NamedRange control.

System_CAPS_pubpropertyDisplayFormat

Gets an object that represents the display settings for the specified range.

System_CAPS_pubpropertyEnd

Gets a Microsoft.Office.Interop.Excel.Range that represents the cell at the end of the region that contains the NamedRange control.

System_CAPS_pubpropertyEntireColumn

Gets a Microsoft.Office.Interop.Excel.Range that represents the entire column (or columns) that contains the NamedRange control.

System_CAPS_pubpropertyEntireRow

Gets a Microsoft.Office.Interop.Excel.Range that represents the entire row (or rows) that contains the NamedRange control.

System_CAPS_pubpropertyErrors

Gets an Errors object that enables you to access error checking options.

System_CAPS_pubpropertyFont

Gets a Font that represents the font of the NamedRange control.

System_CAPS_pubpropertyFormatConditions

Gets a FormatConditions collection that represents all the conditional formats for the NamedRange control.

System_CAPS_pubpropertyFormula

Gets or sets the NamedRange control's formula in A1-style notation.

System_CAPS_pubpropertyFormulaArray

Gets or sets the array formula of the NamedRange control.

System_CAPS_pubpropertyFormulaHidden

Gets or sets a value that indicates whether the formula in the NamedRange control will be hidden when the worksheet is protected.

System_CAPS_pubpropertyFormulaLocal

Gets or sets the formula for the NamedRange control, using A1-style references in the language of the user.

System_CAPS_pubpropertyFormulaR1C1

Gets or sets the formula for the object, using R1C1-style notation.

System_CAPS_pubpropertyFormulaR1C1Local

Gets or sets the formula for the NamedRange control, using R1C1-style notation in the language of the user.

System_CAPS_pubpropertyHasArray

Gets a value that indicates whether the NamedRange control is part of an array formula.

System_CAPS_pubpropertyHasFormula

Gets a value that indicates whether all cells in the NamedRange control contain formulas.

System_CAPS_pubpropertyHeight

Gets the height of the NamedRange control.

System_CAPS_pubpropertyHidden

Gets or sets an object that indicates whether the rows or columns are hidden.

System_CAPS_pubpropertyHorizontalAlignment

Gets or sets the horizontal alignment for the NamedRange control.

System_CAPS_pubpropertyHyperlinks

Gets a Hyperlinks collection that represents the hyperlinks in the NamedRange control.

System_CAPS_pubpropertyID

Gets or sets the identifying label for the NamedRange control when the page is saved as a Web page.

System_CAPS_pubpropertyIndentLevel

Gets or sets the indent level for the NamedRange control.

System_CAPS_pubpropertyInnerObject

Gets a Microsoft.Office.Interop.Excel.Range that represents the underlying native object for the Microsoft.Office.Tools.Excel.NamedRange.

System_CAPS_pubpropertyInterior

Gets an Interior that represents the interior of the NamedRange control.

System_CAPS_pubpropertyItem

Gets a Microsoft.Office.Interop.Excel.Range that represents a range at an offset to the NamedRange control.

System_CAPS_pubpropertyLeft

Gets the distance from the left edge of column A to the left edge of the NamedRange control.

System_CAPS_pubpropertyListHeaderRows

Gets the number of header rows for the NamedRange control.

System_CAPS_pubpropertyListObject
System_CAPS_pubpropertyLocationInTable

Gets a constant that describes the part of the PivotTable report that contains the upper-left corner of the NamedRange control.

System_CAPS_pubpropertyLocked

Gets or sets a value that indicates whether the NamedRange control is locked.

System_CAPS_pubpropertyMDX

Gets the MDX name for the specified NamedRange object.

System_CAPS_pubpropertyMergeArea

Gets a Microsoft.Office.Interop.Excel.Range that represents the merged range containing the NamedRange control.

System_CAPS_pubpropertyMergeCells

Gets or sets a value that indicates whether the NamedRange control contains merged cells.

System_CAPS_pubpropertyName

Gets or sets a Name object for the NamedRange control.

System_CAPS_pubpropertyNext

Gets a Microsoft.Office.Interop.Excel.Range that represents the next cell.

System_CAPS_pubpropertyNumberFormat

Gets or sets the format code for the NamedRange control.

System_CAPS_pubpropertyNumberFormatLocal

Gets or sets the format code for the NamedRange control in the language of the user.

System_CAPS_pubpropertyOffset

Gets a Microsoft.Office.Interop.Excel.Range that is offset from the NamedRange control.

System_CAPS_pubpropertyOrientation

Gets or sets the text orientation.

System_CAPS_pubpropertyOutlineLevel

Gets or sets the current outline level of the NamedRange control.

System_CAPS_pubpropertyPageBreak

Gets or sets the location of a page break.

System_CAPS_pubpropertyParent

Gets the parent object of the NamedRange control.

System_CAPS_pubpropertyPhonetic

Gets the Phonetic object, which contains information about a specific phonetic text string in the NamedRange control.

System_CAPS_pubpropertyPhonetics

Gets the Phonetics collection of the NamedRange control.

System_CAPS_pubpropertyPivotCell

Gets a PivotCell that represents a cell in a PivotTable report.

System_CAPS_pubpropertyPivotField

Gets a PivotField that represents the PivotTable field containing the upper left corner of the NamedRange control.

System_CAPS_pubpropertyPivotItem

Gets a PivotItem that represents the PivotTable item containing the upper left corner of the NamedRange control.

System_CAPS_pubpropertyPivotTable

Gets a PivotTable that represents the PivotTable report containing the upper left corner of the NamedRange control, or the PivotTable report associated with the PivotChart report.

System_CAPS_pubpropertyPrecedents

Gets a Microsoft.Office.Interop.Excel.Range that represents all the precedents of the NamedRange control.

System_CAPS_pubpropertyPrefixCharacter

Gets the prefix character for the NamedRange control.

System_CAPS_pubpropertyPrevious

Gets a Microsoft.Office.Interop.Excel.Range that represents the previous cell.

System_CAPS_pubpropertyQueryTable

Gets a QueryTable that represents the query table that intersects the NamedRange control.

System_CAPS_pubpropertyReadingOrder

Gets or sets the reading order for the NamedRange control.

System_CAPS_pubpropertyRefersTo

Gets or sets the formula that the NamedRange control is defined to refer to, using A1-style notation.

System_CAPS_pubpropertyRefersToLocal

Gets or sets the formula that the NamedRange control is defined to refer to, using A1-style notation in the language of the user.

System_CAPS_pubpropertyRefersToR1C1

Gets or sets the formula that the NamedRange control is defined to refer to, using R1C1-style notation.

System_CAPS_pubpropertyRefersToR1C1Local

Gets or sets the formula that the NamedRange control is defined to refer to, using R1C1-style notation in the language of the user.

System_CAPS_pubpropertyRefersToRange

Gets the Microsoft.Office.Interop.Excel.Range referred to by a NamedRange control.

System_CAPS_pubpropertyResize

Gets a resized Microsoft.Office.Interop.Excel.Range based on the NamedRange control.

System_CAPS_pubpropertyRow

Gets the number of the first row of the first area in the NamedRange control.

System_CAPS_pubpropertyRowHeight

Gets or sets the height of all the rows in the NamedRange control, measured in points.

System_CAPS_pubpropertyRows

Gets a Microsoft.Office.Interop.Excel.Range that represents one or more rows in the NamedRange control.

System_CAPS_pubpropertyServerActions

Gets the actions that can be performed on the Microsoft Office SharePoint server for a NamedRange object.

System_CAPS_pubpropertyShowDetail

Gets or sets an object that indicates whether the outline is expanded for the NamedRange control (so that the detail of the column or row is visible).

System_CAPS_pubpropertyShrinkToFit

Gets or sets a value that indicates whether text automatically shrinks to fit in the available column width.

System_CAPS_pubpropertySite

(Inherited from IComponent.)

System_CAPS_pubpropertySoundNote

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

System_CAPS_pubpropertySparklineGroups

Gets an object that represents an existing group of sparklines from the specified range.

System_CAPS_pubpropertyStyle

Gets or sets a Style that represents the style of the NamedRange control.

System_CAPS_pubpropertySummary

Gets a value that indicates whether the range is an outlining summary row or column.

System_CAPS_pubpropertyTag

Gets or sets the object that contains data about the Tag control.

System_CAPS_pubpropertyText

Gets the text for the NamedRange control.

System_CAPS_pubpropertyTop

Gets the distance, in points, from the top edge of row 1 (one) to the top edge of the NamedRange control.

System_CAPS_pubpropertyUseStandardHeight

Gets or sets a value that indicates whether the row height of the NamedRange control equals the standard height of the sheet.

System_CAPS_pubpropertyUseStandardWidth

Gets or sets a value that indicates whether the column width of the NamedRange control equals the standard width of the sheet.

System_CAPS_pubpropertyValidation

Gets a Validation object that represents data validation for the NamedRange control.

System_CAPS_pubpropertyValue

Gets or sets the value of the NamedRange control.

System_CAPS_pubpropertyValue2

Gets or sets the value of the NamedRange control.

System_CAPS_pubpropertyVerticalAlignment

Gets or sets the vertical alignment of the NamedRange control.

System_CAPS_pubpropertyWidth

Gets the width of the NamedRange control in points.

System_CAPS_pubpropertyWorksheet

Gets a Microsoft.Office.Interop.Excel.Worksheet that represents the worksheet that contains the NamedRange control.

System_CAPS_pubpropertyWrapText

Gets or sets a value that indicates whether Microsoft Office Excel wraps the text in the NamedRange control.

System_CAPS_pubpropertyXPath

Gets an XPath that represents the Xpath of the element mapped to the NamedRange control.

Return to top
Show: