ListObject Properties
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
| Name | Description | |
|---|---|---|
 | Active | 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. |
| AlternativeText | Gets or sets the descriptive (alternative) text string for the specified table. |
| Application | Gets an Application that represents either the Microsoft Office Excel application or the creator of the ListObject. |
| AutoFilter | Gets a filtered table. |
| AutoSelectRows | Gets or sets a value that indicates whether the entire row is selected when the SelectedIndex changes. |
| AutoSetDataBoundColumnHeaders | Gets or sets a value that determines whether the column headers are automatically set to match the data source. |
| BindingContext | (Inherited from IBindableComponent.) |
| Comment | Gets or sets a comment that is associated with the ListObject. |
| Container | This API supports the product infrastructure and is not intended to be used directly from your code. |
| Creator | Gets the application in which the ListObject was created. |
| DataBindings | (Inherited from IBindableComponent.) |
| DataBodyRange | Gets a Range that represents the range that contains the data area in the list between the header row and the insert row. |
| DataBoundFormat | Gets or sets the format style for data-bound ListObject controls. |
| DataBoundFormatSettings | Gets or sets which FormatSettings of the specified XlRangeAutoFormat are applied to the ListObject control. |
| DataMember | Gets or sets the specific data member in a multimember data source to bind to the ListObject control. |
| DataSource | Gets or sets the source that contains a list of values that are used to populate the items within the control. |
| DefaultDataSourceUpdateMode | Gets or sets the default DataSourceUpdateMode. |
| DisplayName | Gets or sets the displayed name. |
| DisplayRightToLeft | Gets a value that indicates whether the ListObject is displayed from right to left instead of from left to right. |
| HeaderRowRange | Gets a Range that represents the range of the header row. |
| InnerObject | Gets a Microsoft.Office.Interop.Excel::ListObject that represents the underlying native object for the Microsoft.Office.Tools.Excel::ListObject. |
| InsertRowRange | Gets a Range that represents the Insert row, if any, of the ListObject control. |
| IsBinding | Gets a value that indicates whether data binding is active. |
| IsSelected | Gets a value that indicates whether the ListObject is selected. |
| ListColumns | Gets a ListColumns collection that represents all the columns in the ListObject control. |
| ListRows | Gets a ListRows object that represents all the rows of data in the ListObject control. |
| MappedColumns | This API supports the product infrastructure and is not intended to be used directly from your code. |
| Name | Gets or sets the name of the ListObject control. |
| Parent | Gets the parent object of the ListObject control. |
| QueryTable | Gets the QueryTable that provides a link for the ListObject control to the list server. |
| Range | Gets a Range that represents the range to which the ListObject applies. |
| SaveSortOrder | Gets or sets a value that indicates whether the row order of the ListObject control is saved in the worksheet. |
| SelectedIndex | Gets or sets the index of the row that is currently selected. |
| SharePointURL | Gets the URL of the SharePoint list for a given ListObject control. |
| ShowAutoFilter | Gets or sets a value that indicates whether the AutoFilter is displayed. |
| ShowHeaders | Gets or sets a value that indicates whether the header information should be displayed. |
| ShowTableStyleColumnStripes | Gets or sets a value that indicates whether the Column Stripes table style is used. |
| ShowTableStyleFirstColumn | Gets or sets a value that indicates whether the first column is formatted. |
| ShowTableStyleLastColumn | Gets or sets a value that indicates whether the last column is formatted. |
| ShowTableStyleRowStripes | Gets or sets a value that indicates whether the Row Stripes table style is used. |
| ShowTotals | Gets or sets a value that indicates whether the Total row is visible. |
| Site | (Inherited from IComponent.) |
| Sort | Gets the sort column or columns, and the sort order for the ListObject collection. |
| SourceType | Gets the current source of the list. |
| Summary | Gets or sets the description associated with the alternative text string for the specified table. |
| TableStyle | Gets or sets the table style. |
| Tag | Gets or sets the object that contains data about the Tag control. |
| TotalsRowRange | Gets a Range that represents the Total row of the ListObject control. |
| XmlMap | Gets an XmlMap that represents the schema map used for the list. |