TableStyle TableStyle TableStyle Interface

Definition

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

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 _Default _Default
Application Application 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 BuiltIn BuiltIn

True if the style is a built-in style. Read-only.

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only.

Name Name Name

Returns the name of the object. Read-only.

NameLocal NameLocal NameLocal

Returns or sets the name of the object, in the language of the user. Read-only.

Parent Parent Parent

Returns the parent object for the specified object. Read-only.

ShowAsAvailablePivotTableStyle ShowAsAvailablePivotTableStyle ShowAsAvailablePivotTableStyle

Sets or returns if a style is shown in the gallery for PivotTable styles or not. Read/write.

ShowAsAvailableSlicerStyle ShowAsAvailableSlicerStyle ShowAsAvailableSlicerStyle

Gets or sets whether the specified table style is shown as available in the slicer styles gallery.

ShowAsAvailableTableStyle ShowAsAvailableTableStyle ShowAsAvailableTableStyle

Returns or sets a table style shown as available in the table styles gallery. Read/write.

ShowAsAvailableTimelineStyle ShowAsAvailableTimelineStyle 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 TableStyleElements TableStyleElements

Returns the TableStyleElements object. Read-only.

Methods

Delete() Delete() Delete()

Deletes the TableStyle object.

Duplicate(Object) Duplicate(Object) Duplicate(Object)

Duplicates the TableStyle object and returns a reference to the new copy.

Applies to