Clears the collection. Syntax Remarks If any WorksheetTable instances in the workbook have their style removed due to this operation, their style will be set to the Workbook.DefaultTableStyle.
Determines whether the specified WorksheetTableStyle is contained in the collection. Syntax Parameters style The table style to find in the collection. Return Value True if the style is in the collection; False otherwise.
Gets the number of custom WorksheetTableStyle instances in the collection. Syntax
Gets the index of the specified style in the collection. Syntax Parameters style The style to find in the collection. Return Value The 0-based index of the specified style in the collection or -1 if the style is not in the collection. Exceptions Exception Description System.ArgumentNullException style is null.
Gets the WorksheetTableStyle at the specified index. Syntax Parameters index The index at which to get the WorksheetTableStyle. Property Value The WorksheetTableStyle instance at the specified index. Exceptions Exception Description System.ArgumentOutOfRangeException index is less than 0 or greater than or equal t...
Gets the WorksheetTableStyle with the specified name. Syntax Parameters name The name of the WorksheetTableStyle to find. Property Value The WorksheetTableStyle instance with the specified name or null if a table style with that name does not exist. Remarks Table style names are compared case-insensitively.
Gets the WorksheetTableStyle at the specified index. Overload List Exceptions Exception Description System.ArgumentOutOfRangeException index is less than 0 or greater than or equal to Count.
Removes the specified WorksheetTableStyle from the collection. Syntax Parameters style The table style to remove from the collection. Return Value True if the style was in the collection and therefore removed; False otherwise. Exceptions Exception Description System.ArgumentNullException style is null. Remarks If ...
Removes the WorksheetTableStyle at the specified index. Syntax Parameters index The index of the table style to remove. Exceptions Exception Description System.ArgumentOutOfRangeException index is less than 0 or greater than or equal to Count. Remarks If any WorksheetTable instances in the workbook have their styl...
Represents a custom view in Microsoft Excel. Syntax Remarks Custom views provide a way to save display options and optionally print options for the workbook and each worksheet in the workbook. These options can be different from the options currently set on the workbook and worksheets. Multiple custom views can be...