GrapeCity.Documents.Excel.ITableStyle

ITableStyle Interface

Represents a single style that can be applied to a table.

An ITableStyle can be a built-in style or a custom style stored in the workbook. Use this interface to access the style name, inspect whether the style is built in, and modify its ITableStyleElements before applying it to a table.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface ITableStyle

Public Interface ITableStyle

Examples

ITableStyle tableStyle = workbook.TableStyles["TableStyleLight11"];
worksheet.Tables.Add(worksheet.Range["A1:B3"], true);
worksheet.Tables[0].TableStyle = tableStyle;

Properties

Name	Description
BuiltIn	Gets whether the style is a built-in style (read-only).
Name	Gets the name of the table style.
ShowAsAvailablePivotStyle	Gets or sets whether the specified table style is shown as available in the pivot styles gallery.
ShowAsAvailableSlicerStyle	Gets or sets whether the specified table style is shown as available in the slicer styles gallery.
ShowAsAvailableTableStyle	Gets or sets a table style shown as available in the table styles gallery (read or write).
TableStyleElements	Returns the ITableStyleElements object (read-only).

Methods

Name Description

Name	Description
Delete()	Deletes the ITableStyle object.
Duplicate(string)	Returns a duplicate of this ITableStyle object with the specified name. If `newName` is `null`, this method forwards the current style name to the duplication logic. If the specified name already exists, a valid style name is generated for the new copy.

Delete()

Deletes the ITableStyle object.

Duplicate(string)

Returns a duplicate of this ITableStyle object with the specified name.

If newName is null, this method forwards the current style name to the duplication logic. If the specified name already exists, a valid style name is generated for the new copy.