Version

Search Results

RemoveAt Method (WorksheetTableCollection)

Removes the WorksheetTable at the specified index. Syntax Parameters index The 0-based index of the WorksheetTable to remove.convertToRange True to apply the table style formatting to the cells Exceptions Exception Description System.ArgumentOutOfRangeException index is less than 0 or greater than or equal to Coun...

WorksheetTableColumn Class

Represents a column in a WorksheetTable. Syntax Remarks Each column contains various settings for controlling the contents, formatting, sorting, and filtering within it.

WorksheetTableColumnArea Enumeration

Represents the various areas which can have a format applied at the table column level. Syntax Members Member Description DataArea The format is applied to the data area of the table column. HeaderCell The format is applied to the header cell of the table column. TotalCell The format is applied to the total cell o...

WorksheetTableColumnCollection Class

A read-only collection of all WorksheetTableColumn instances which exist in a WorksheetTable. Syntax

WorksheetTableColumnCollection Class Members

Public Properties Public Methods

Contains Method (WorksheetTableColumnCollection)

Determines whether the specified WorksheetTableColumn is in the collection. Syntax Parameters column The column to find in the collection. Return Value True if the specified column is in the collection; False otherwise.

Count Property (WorksheetTableColumnCollection)

Gets the number of WorksheetTableColumn instances in the collection. Syntax Property Value The number of columns in the collection.

IndexOf Method (WorksheetTableColumnCollection)

Gets the index of the specified WorksheetTableColumn in the collection. Syntax Parameters column The WorksheetTableColumn to find in the collection. Return Value The 0-based index of the specified WorksheetTableColumn in the collection or -1 if the item is not in the collection.