ListObject Members (2007 System)
Include Protected Members
Include Inherited Members
The ListObject control displays data in a series of rows and columns.
The ListObject type exposes the following members.
Constructors
Name
Description
.gif "Public method")
Infrastructure. Overloaded.
Top
Methods
Name
Description
Infrastructure.
.gif "Protected method")
(Inherited from RemoteComponent.)
Deletes a dynamically created ListObject control, clears the cell data from the worksheet, and removes the control from the ControlCollection.
Removes data binding from the ListObject control.
Overloaded.
Infrastructure.
Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Exports a ListObject to Visio.
(Inherited from RemoteComponent.)
Serves as a hash function for a particular type. (Inherited from Object.)
(Inherited from RemoteComponent.)
(Inherited from RemoteComponent.)
Gets the type of the current instance. (Inherited from Object.)
.gif "Static member")
Returns an Excel Microsoft.Office.Tools.Excel.ListObject host control that extends the functionality of the specified native Excel ListObject.
Returns a value that indicates whether an Excel Microsoft.Office.Tools.Excel.ListObject host control has been created for the specified native Excel ListObject.
(Inherited from RemoteComponent.)
Creates a shallow copy of the current Object. (Inherited from Object.)
Infrastructure. (Inherited from RemoteBindableComponent.)
Publishes the ListObject control to a server that is running Microsoft Windows SharePoint Services.
Updates the ListObject control with current data and schema from a server that is running Microsoft Windows SharePoint Services.
Updates the ListObject data row that is associated with the specified data row.
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.
Enables a ListObject control to be resized over a new range.
Overloaded. Binds a ListObject control to a data source.
(Inherited from RemoteComponent.)
Returns a string that represents the current object. (Inherited from Object.)
Removes the link to a Microsoft Windows SharePoint Services site from a ListObject control.
Removes the list functionality from a ListObject control.
Updates the list on a Microsoft Windows SharePoint Services site with the changes made to the ListObject control in the worksheet.
Top
Properties
Name
Description
.gif "Public property")
Infrastructure.
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.
Gets an Application that represents either the Microsoft Office Excel application or the creator of the ListObject.
Gets a filtered table.
Gets or sets a value that indicates whether the entire row is selected when the SelectedIndex changes.
Gets or sets a value that determines whether the column headers are automatically set to match the data source.
Gets or sets the System.Windows.Forms.BindingContext for the component. (Inherited from RemoteBindableComponent.)
Gets or sets a comment that is associated with the ListObject.
(Inherited from RemoteComponent.)
Infrastructure. (Inherited from RemoteBindableComponent.)
Gets the application in which the ListObject was created.
Gets the Binding objects for the component. (Inherited from RemoteBindableComponent.)
Gets a Range that represents the range that contains the data area in the list between the header row and the insert row.
Gets or sets the format style for data-bound ListObject controls.
Gets or sets which FormatSettings of the specified XlRangeAutoFormat are applied to the ListObject control.
Gets or sets the specific data member in a multimember data source to bind to the ListObject control.
Gets or sets the source that contains a list of values that are used to populate the items within the control.
Gets or sets the default DataSourceUpdateMode for the component. (Inherited from RemoteBindableComponent.)
.gif "Protected property")
(Inherited from RemoteComponent.)
Gets or sets the displayed name.
Gets a value that indicates whether the ListObject is displayed from right to left instead of from left to right.
Gets a Range that represents the range of the header row.
(Inherited from RemoteComponent.)
(Inherited from RemoteComponent.)
Gets a ListObject that represents the underlying native object for the Microsoft.Office.Tools.Excel.ListObject.
(Inherited from RemoteComponent.)
Gets a Range that represents the Insert row, if any, of the ListObject control.
Gets a value that indicates whether data binding is active.
Gets a value that indicates whether the ListObject is selected.
(Inherited from RemoteComponent.)
Gets a ListColumns collection that represents all the columns in the ListObject control.
Gets a ListRows object that represents all the rows of data in the ListObject control.
Infrastructure.
Gets or sets the name of the ListObject control.
Gets the parent object of the ListObject control.
(Inherited from RemoteComponent.)
Gets the QueryTable that provides a link for the ListObject control to the list server.
Gets a Range that represents the range to which the ListObject applies.
Gets or sets a value that indicates whether the row order of the ListObject control is saved in the worksheet.
Gets or sets the index of the row that is currently selected.
Gets the URL of the SharePoint list for a given ListObject control.
Gets or sets a value that indicates whether the AutoFilter is displayed.
Gets or sets a value that indicates whether the header information should be displayed.
Gets or sets a value that indicates whether the Column Stripes table style is used.
Gets or sets a value that indicates whether the first column is formatted.
Gets or sets a value that indicates whether the last column is formatted.
Gets or sets a value that indicates whether the Row Stripes table style is used.
Gets or sets a value that indicates whether the Total row is visible.
(Inherited from RemoteComponent.)
Gets the sort column or columns, and the sort order for the ListObject collection.
Gets the current source of the list.
Gets or sets the table style.
(Inherited from RemoteComponent.)
Gets a Range that represents the Total row of the ListObject control.
Gets an XmlMap that represents the schema map used for the list.
Top
Events
Name
Description
.gif "Public event")
Occurs just before an attempt to add a new row to a ListObject control that is bound to data.
Occurs when the ListObject control is double-clicked, before the default double-click action.
Occurs when the ListObject control is right-clicked, before the default right-click action.
Occurs when the value of the BindingContext property changes. (Inherited from RemoteBindableComponent.)
Occurs when something changes in the ListObject control.
Occurs when a condition causes the data binding of a ListObject control to fail.
Occurs when the value of the DataMember property changes.
Occurs when the value of the DataSource property changes.
Occurs when selection moves from the ListObject control to outside of the ListObject control.
(Inherited from RemoteComponent.)
Occurs when a user tries to add a row to a data-bound ListObject control, but the row cannot be added.
Occurs when a user performs an action that is not allowed, and the ListObject control then reverts back to its original state.
Occurs when the ListObject control is selected.
Occurs when the value of the SelectedIndex property changes.
Occurs when the selection changes inside the ListObject control.
Top
Explicit Interface Implementations
Name
Description
.gif "Explicit interface implemetation")
.gif "Private method")
ISupportInitializeControl.InitializeControl
Infrastructure.
Top