ListObject Members
Visual Studio 2005
The ListObject control displays data in a series of rows and columns.
The following tables list the members exposed by the ListObject type.
(see also
Protected Properties
)
Top
| Name | Description | |
|---|---|---|
 | _Default | |
| | 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. |
| | Application | Gets an Application that represents either the Microsoft Office Excel application or the creator of the ListObject. |
| | 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 BindableComponent.) |
| | Container | (Inherited from Component.) |
| | Creator | Gets the application in which the ListObject was created. |
| | DataBindings | (Inherited from BindableComponent.) |
| | 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. |
| | 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 | |
| | 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. |
| | ShowTotals | Gets or sets a value that indicates whether the Total row is visible. |
| | Site | (Inherited from Component.) |
| | SourceType | Gets the current source of the list. |
| | Tag | Gets or sets an object that contains data about the ListObject 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. |
| Name | Description | |
|---|---|---|
| | CanRaiseEvents | (Inherited from Component.) |
| | ContainerComponent | (Inherited from BindableComponent.) |
| | DesignMode | (Inherited from Component.) |
| | Events | (Inherited from Component.) |
(see also
Protected Methods
)
Top
| Name | Description | |
|---|---|---|
| | BeginInit | |
| | CreateObjRef | (Inherited from MarshalByRefObject.) |
| | Delete | Deletes a dynamically created ListObject control, clears the cell data from the worksheet, and removes the control from the ControlCollection. |
| | Disconnect | Removes data binding from the ListObject control. |
| | Dispose | Overloaded. (Inherited from Component.) |
| | EndInit | |
| | Equals | Overloaded. (Inherited from Object.) |
| | GetHashCode | (Inherited from Object.) |
| | GetLifetimeService | (Inherited from MarshalByRefObject.) |
| | GetType | (Inherited from Object.) |
| | InitializeLifetimeService | (Inherited from MarshalByRefObject.) |
| | Publish | Publishes the ListObject control to a server that is running Microsoft Windows SharePoint Services. |
 | ReferenceEquals | (Inherited from Object.) |
| | Refresh | Updates the ListObject control with current data and schema from a server that is running Microsoft Windows SharePoint Services. |
| | RefreshDataRow | Updates the ListObject data row that is associated with the specified data row. |
| | RefreshDataRows | Updates all of the rows in the ListObject with data from the data source. |
| | ResetPersistedBindingInformation | Clears information about changes made to the ListObject control by the user. |
| | Resize | Enables a ListObject control to be resized over a new range. |
| | SetDataBinding | Overloaded. Binds a ListObject control to a data source. |
| | ToString | (Inherited from Component.) |
| | Unlink | Removes the link to a Microsoft Windows SharePoint Services site from a ListObject control. |
| | Unlist | Removes the list functionality from a Microsoft.Office.Interop.Excel.ListObject control. |
| | UpdateChanges | Updates the list on a Microsoft Windows SharePoint Services site with the changes made to the ListObject control in the worksheet. |
| Name | Description | |
|---|---|---|
| | Dispose | Overloaded. (Inherited from Component.) |
| | Finalize | (Inherited from Component.) |
| | GetService | (Inherited from Component.) |
| | MemberwiseClone | Overloaded. (Inherited from MarshalByRefObject.) |
| | OnBindingContextChanged | (Inherited from BindableComponent.) |
| Name | Description | |
|---|---|---|
| | BeforeAddDataBoundRow | Occurs just before an attempt to add a new row to a ListObject control that is bound to data. |
| | BeforeDoubleClick | Occurs when the ListObject control is double-clicked, before the default double-click action. |
| | BeforeRightClick | Occurs when the ListObject control is right-clicked, before the default right-click action. |
| | BindingContextChanged | (Inherited from BindableComponent.) |
| | Change | Occurs when something changes in the ListObject control. |
| | DataBindingFailure | Occurs when a condition causes the data binding of a ListObject control to fail. |
| | DataMemberChanged | Occurs when the value of the DataMember property changes. |
| | DataSourceChanged | Occurs when the value of the DataSource property changes. |
| | Deselected | Occurs when selection moves from the ListObject control to outside of the ListObject control. |
| | Disposed | (Inherited from Component.) |
| | ErrorAddDataBoundRow | Occurs when a user tries to add a row to a data-bound ListObject control, but the row cannot be added. |
| | OriginalDataRestored | Occurs when a user performs an action that is not allowed, and the ListObject control then reverts back to its original state. |
| | Selected | Occurs when the ListObject control is selected. |
| | SelectedIndexChanged | Occurs when the value of the SelectedIndex property changes. |
| | SelectionChange | Occurs when the selection changes inside the ListObject control. |
