TableStyle Interface

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

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

public interface class TableStyle

[System.Runtime.InteropServices.Guid("000244A7-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface TableStyle

Public Interface TableStyle

Attributes

GuidAttribute InterfaceTypeAttribute

Remarks

A table style defines the formatting for one or all of the elements of a table or PivotTable. For example, a column is an element of a table. A table style can define that columns in a table are formatted with alternating formatting (also known as banding or stripes).

Properties

_Default
Application	When used without an object qualifier, this property returns an _Application object that represents the Microsoft Office Excel application. When used with an object qualifier, this property returns an _Application object that represents the creator of the specified object. Read-only.
BuiltIn	True if the style is a built-in style. Read-only.
Creator	Returns a 32-bit integer that indicates the application in which this object was created. Read-only.
Name	Returns the name of the object. Read-only.
NameLocal	Returns or sets the name of the object, in the language of the user. Read-only.
Parent	Returns the parent object for the specified object. Read-only.
ShowAsAvailablePivotTableStyle	Sets or returns if a style is shown in the gallery for PivotTable styles or not. Read/write.
ShowAsAvailableSlicerStyle	Gets or sets whether the specified table style is shown as available in the slicer styles gallery.
ShowAsAvailableTableStyle	Returns or sets a table style shown as available in the table styles gallery. Read/write.
ShowAsAvailableTimelineStyle	Returns or sets whether the specified table style is shown as available in the timeline styles gallery. Boolean (bool in C#). Read/write
TableStyleElements	Returns the TableStyleElements object. Read-only.

Methods

Delete()	Deletes the TableStyle object.
Duplicate(Object)	Duplicates the TableStyle object and returns a reference to the new copy.