Skip to main content
Row

TableCollection Methods

A collection of tables contained in a worksheet.
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