Skip to main content
Row

TableCollection Members

A collection of tables contained in a worksheet.

Properties

Name Description
Count Gets the number of elements contained in the ICollection. Inherited from ICollection.
IsSynchronized Gets a value indicating whether access to the ICollection is synchronized (thread safe). Inherited from ICollection.
SyncRoot Gets an object that can be used to synchronize access to the ICollection. Inherited from ICollection.

Methods

Name Description
Add(CellRange, Boolean) Creates a table including the specified range of cells and adds it to the collection.
Add(CellRange, String, Boolean) Creates a table including the specified range of cells and adds it to the collection.
Add(Object, CellRange, ExternalDataSourceOptions) Creates a table from the specified range, adds it to the collection and binds it to the data source.
Add(Object, CellRange) Creates a table from the specified range, adds it to the collection and binds it to the data source.
Add(Object, Int32, Int32, ExternalDataSourceOptions) Creates a table starting from the specified row and column, adds it to the collection and binds it to the data source using the specified options.
Add(Object, Int32, Int32) Creates a table starting from the specified row and column, adds it to the collection and binds it to the data source.
Clear() Removes all tables from the worksheet.
Contains(Table) Indicates whether the collection contains the specified table.
CopyTo(Array, Int32) Copies the elements of the ICollection to an Array, starting at a particular Array index. Inherited from ICollection.
GetEnumerator() Returns an enumerator that iterates through the collection. Inherited from IEnumerable<T>.
GetTables(CellRange) Gets tables contained in the specified cell range.
IndexOf(Table) Returns the index of the specified table in the collection.
Remove(Table) Removes the specified table from the collection.
RemoveAt(Int32) Removes the table at the specified index location from the current collection.
See Also