Formats a region as a table and adds an associated WorksheetTable to the collection. Overload List
Clears the collection and removes all tables from the worksheet. Syntax
Determines whether the specified WorksheetTable is in the collection. Syntax Parameters table The WorksheetTable to find in the collection. Return Value True if the WorksheetTable is in the collection; False otherwise.
Gets the number of tables in the collection. Syntax Property Value The number of tables in the collection.
Determines whether a WorksheetTable with the specified name is in the collection. Syntax Parameters name The name of the WorksheetTable to find. Return Value True if a WorksheetTable with the specified name is in the collection; False otherwise. Remarks Table names are compared case-insensitively.
Gets the index of the specified WorksheetTable in the collection. Syntax Parameters table The WorksheetTable to find in the collection. Return Value The 0-based index of the specified WorksheetTable in the collection or -1 if the item is not in the collection.
Gets the WorksheetTable at the specified index. Syntax Parameters index The zero-based index of the WorksheetTable to get. Property Value The WorksheetTable at the specified index. Exceptions Exception Description System.ArgumentOutOfRangeException index is less than zero or index is greater than or equal to Count...
Gets the WorksheetTable with the specified name. Syntax Parameters name The name of the WorksheetTable to get. Property Value The WorksheetTable with the specified name. Exceptions Exception Description System.InvalidOperationException A WorksheetTable with the specified name does not exist in the collection. Rema...
Gets the WorksheetTable at the specified index. Overload List Exceptions Exception Description System.ArgumentOutOfRangeException index is less than zero or index is greater than or equal to Count.
Removes the WorksheetTable from the collection. Syntax Parameters table The WorksheetTable to remove from the collection.convertToRange True to apply the table style formatting to the cells Return Value True if the WorksheetTable was found and removed; False otherwise.