TableStyleElement 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 table style element.

public interface class TableStyleElement

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

Public Interface TableStyleElement

Attributes: GuidAttribute InterfaceTypeAttribute

Remarks

Table styles define formatting for one or all of the elements of a table or PivotTable. For example, a header row is an element of a table. A table style can define that the fill color of the header row is red.

Each table style element in a table can have formatting specified in a table style applied to the element.

Properties

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.
Borders	Returns the borders of a table style element. Read-only.
Creator	Returns a 32-bit integer that indicates the application in which this object was created. Read-only.
Font	Returns the font of the specified object. Read-only.
HasFormat	Returns whether a table style element has formatting applied to the specified element. Read-only.
Interior	Returns an Interior object that represents the interior of the specified object. Read-only.
Parent	Returns the parent object for the specified object. Read-only.
StripeSize	Returns or sets the size of banding. Read/write.

Methods

Clear()

Clears the formatting for this element.

Applies to