Back to Devexpress

TableCollection Members

officefileapi-devexpress-dot-spreadsheet-dot-tablecollection-dot-underscore-members.md

latest5.1 KB
Original Source

TableCollection Members

A collection of tables contained in a worksheet.

Properties

NameDescription
CountGets the number of elements contained in the ICollection. Inherited from ICollection.
IsSynchronizedGets a value indicating whether access to the ICollection is synchronized (thread safe). Inherited from ICollection.
SyncRootGets an object that can be used to synchronize access to the ICollection. Inherited from ICollection.

Methods

NameDescription
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

TableCollection Interface

DevExpress.Spreadsheet Namespace