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