TableStyle Interface

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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.

Applies to