Version

Search Results

Clear Method (WorksheetDataTableCollection)

Clears all data tables from the collection. Syntax Remarks Once a data table is removed from the collection, it can no longer be used.

Count Property (WorksheetDataTableCollection)

Gets the number of data tables in the collection. Syntax Property Value The number of data tables in the collection.

Item Property (WorksheetDataTableCollection)

Gets the data table at the specified index in the collection. Syntax Parameters index The zero-based index of the data table to get. Property Value The data table at the specified index.

Remove Method (WorksheetDataTableCollection)

Removes the specified data table from the collection. Syntax Parameters dataTable The data table to remove from the collection. Return Value True if the dataTable was successfully removed; False if the dataTable was not in the collection. Remarks Once a data table is removed from the collection, it can no longer b...

RemoveAt Method (WorksheetDataTableCollection)

Removes the data table at the specified index from the collection. Syntax Parameters index The zero-based index of the data table to remove from the collection. Remarks Once a data table is removed from the collection, it can no longer be used.

CellsInTable Property

Gets or sets the region of cells in the data table. Syntax Property Value The region of cells in the data table. Exceptions Exception Description System.ArgumentNullException The value assigned is null. System.InvalidOperationException The value is assigned after the data table has been removed from the worksheet....

ColumnInputCell Property

Gets or sets the cell used as the column-input cell in the data table. Syntax Property Value The cell used as the column-input cell in the data table. Exceptions Exception Description System.ArgumentException The assigned value does not belong to the same worksheet as the data table. System.InvalidOperationExcepti...

RowInputCell Property

Gets or sets the cell used as the row-input cell in the data table. Syntax Property Value The cell used as the row-input cell in the data table. Exceptions Exception Description System.ArgumentException The assigned value does not belong to the same worksheet as the data table. System.InvalidOperationException The...