Static
$tStatic
nextGets the number of data tables in the collection. The number of data tables in the collection.
Creates a new data table and adds it to the collection.
The input cells specified must be different cell references and at least one must be non-null. See the WorksheetDataTable overview for more information on data tables.
ArgumentNullException 'cellsInTable' is null.
ArgumentException 'cellsInTable' is a region which does not belongs to the worksheet which owns this collection.
ArgumentException 'columnInputCell' is not null but does not belong to the worksheet which owns this collection.
ArgumentException 'rowInputCell' is not null but does not belong to the worksheet which owns this collection.
InvalidOperationException Both 'columnInputCell' and 'rowInputCell' are null.
InvalidOperationException 'columnInputCell' and 'rowInputCell' are the same cell.
InvalidOperationException 'columnInputCell' or 'rowInputCell' are contained in the 'cellsInTable' region.
InvalidOperationException One or more of the interior cells of the 'cellsInTable' region (all cells except the left-most column and top row) is an interior cell of another data table or is a cell in an array formula, and the entire range of that other entity extends outside the interior cells of 'cellsInTable'.
The newly created data table.
The region of cells in the data table.
The cell used as the column-input cell in the data table.
The cell used as the row-input cell in the data table.
Gets the data table at the specified index in the collection. The data table at the specified index.
Removes the specified data table from the collection.
Once a data table is removed from the collection, it can no longer be used.
True if the dataTable was successfully removed; False if the dataTable was not in the collection.
The data table to remove from the collection.
Static
compareStatic
compareStatic
equalsStatic
equalsStatic
getStatic
getStatic
getStatic
referenceStatic
static
A collection of WorksheetDataTable instances on a worksheet.