ListObject Properties

 

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

NameDescription
System_CAPS_pubpropertyActive

Gets a value that indicates whether a ListObject control on a worksheet is active; that is, whether the active cell is inside the range of the ListObject control.

System_CAPS_pubpropertyAlternativeText

Gets or sets the descriptive (alternative) text string for the specified table.

System_CAPS_pubpropertyApplication

Gets an Application that represents either the Microsoft Office Excel application or the creator of the ListObject.

System_CAPS_pubpropertyAutoFilter

Gets a filtered table.

System_CAPS_pubpropertyAutoSelectRows

Gets or sets a value that indicates whether the entire row is selected when the SelectedIndex changes.

System_CAPS_pubpropertyAutoSetDataBoundColumnHeaders

Gets or sets a value that determines whether the column headers are automatically set to match the data source.

System_CAPS_pubpropertyBindingContext

(Inherited from IBindableComponent.)

System_CAPS_pubpropertyComment

Gets or sets a comment that is associated with the ListObject.

System_CAPS_pubpropertyContainer

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

System_CAPS_pubpropertyCreator

Gets the application in which the ListObject was created.

System_CAPS_pubpropertyDataBindings

(Inherited from IBindableComponent.)

System_CAPS_pubpropertyDataBodyRange

Gets a Range that represents the range that contains the data area in the list between the header row and the insert row.

System_CAPS_pubpropertyDataBoundFormat

Gets or sets the format style for data-bound ListObject controls.

System_CAPS_pubpropertyDataBoundFormatSettings

Gets or sets which FormatSettings of the specified XlRangeAutoFormat are applied to the ListObject control.

System_CAPS_pubpropertyDataMember

Gets or sets the specific data member in a multimember data source to bind to the ListObject control.

System_CAPS_pubpropertyDataSource

Gets or sets the source that contains a list of values that are used to populate the items within the control.

System_CAPS_pubpropertyDefaultDataSourceUpdateMode

Gets or sets the default DataSourceUpdateMode.

System_CAPS_pubpropertyDisplayName

Gets or sets the displayed name.

System_CAPS_pubpropertyDisplayRightToLeft

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

System_CAPS_pubpropertyHeaderRowRange

Gets a Range that represents the range of the header row.

System_CAPS_pubpropertyInnerObject

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

System_CAPS_pubpropertyInsertRowRange

Gets a Range that represents the Insert row, if any, of the ListObject control.

System_CAPS_pubpropertyIsBinding

Gets a value that indicates whether data binding is active.

System_CAPS_pubpropertyIsSelected

Gets a value that indicates whether the ListObject is selected.

System_CAPS_pubpropertyListColumns

Gets a ListColumns collection that represents all the columns in the ListObject control.

System_CAPS_pubpropertyListRows

Gets a ListRows object that represents all the rows of data in the ListObject control.

System_CAPS_pubpropertyMappedColumns

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

System_CAPS_pubpropertyName

Gets or sets the name of the ListObject control.

System_CAPS_pubpropertyParent

Gets the parent object of the ListObject control.

System_CAPS_pubpropertyQueryTable

Gets the QueryTable that provides a link for the ListObject control to the list server.

System_CAPS_pubpropertyRange

Gets a Range that represents the range to which the ListObject applies.

System_CAPS_pubpropertySaveSortOrder

Gets or sets a value that indicates whether the row order of the ListObject control is saved in the worksheet.

System_CAPS_pubpropertySelectedIndex

Gets or sets the index of the row that is currently selected.

System_CAPS_pubpropertySharePointURL

Gets the URL of the SharePoint list for a given ListObject control.

System_CAPS_pubpropertyShowAutoFilter

Gets or sets a value that indicates whether the AutoFilter is displayed.

System_CAPS_pubpropertyShowHeaders

Gets or sets a value that indicates whether the header information should be displayed.

System_CAPS_pubpropertyShowTableStyleColumnStripes

Gets or sets a value that indicates whether the Column Stripes table style is used.

System_CAPS_pubpropertyShowTableStyleFirstColumn

Gets or sets a value that indicates whether the first column is formatted.

System_CAPS_pubpropertyShowTableStyleLastColumn

Gets or sets a value that indicates whether the last column is formatted.

System_CAPS_pubpropertyShowTableStyleRowStripes

Gets or sets a value that indicates whether the Row Stripes table style is used.

System_CAPS_pubpropertyShowTotals

Gets or sets a value that indicates whether the Total row is visible.

System_CAPS_pubpropertySite

(Inherited from IComponent.)

System_CAPS_pubpropertySort

Gets the sort column or columns, and the sort order for the ListObject collection.

System_CAPS_pubpropertySourceType

Gets the current source of the list.

System_CAPS_pubpropertySummary

Gets or sets the description associated with the alternative text string for the specified table.

System_CAPS_pubpropertyTableStyle

Gets or sets the table style.

System_CAPS_pubpropertyTag

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

System_CAPS_pubpropertyTotalsRowRange

Gets a Range that represents the Total row of the ListObject control.

System_CAPS_pubpropertyXmlMap

Gets an XmlMap that represents the schema map used for the list.

Return to top
Show: