TableStyles Interface

  • Reference

Definition

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

Represents styles that can be applied to a table.

public interface class TableStyles : System::Collections::IEnumerable
[System.Runtime.InteropServices.Guid("000244A8-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface TableStyles : System.Collections.IEnumerable
Public Interface TableStyles
Implements IEnumerable
Attributes
GuidAttribute InterfaceTypeAttribute
Implements
IEnumerable

Remarks

Table styles provide a way to format an entire table or Pivot Table. Table styles replaces the existing auto format feature for formatting an entire table.

Table styles differ from auto format in the following ways:

  • You can create and re-use your own custom table styles.
  • Table styles work with themes.
  • Changing the document theme's color scheme and/or font scheme will change the look of the built-in table styles.
  • Table styles can reapply styles to objects like PivotTables and tables as the object changes. The tables will remember the style applied to them and will re-display appropriately when cells are added, removed, hidden, and shown.
  • Table styles have a visual user interface in the Ribbon.

Properties

_Default[Object]

Reserved for internal use.
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.
Count

Returns the number of objects in the collection. Read-only.
Creator

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

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

Methods

Add(String)

Creates a new TableStyle object and adds it to the collection.
GetEnumerator()
Item(Object)

Returns a single object from a collection.

Applies to