Freigeben über


TableStyles-Klasse

Table Styles.When the object is serialized out as xml, its qualified name is x:tableStyles.

Vererbungshierarchie

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.Spreadsheet.TableStyles

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'Declaration
<ChildElementInfoAttribute(GetType(TableStyle))> _
Public Class TableStyles _
    Inherits OpenXmlCompositeElement
'Usage
Dim instance As TableStyles
[ChildElementInfoAttribute(typeof(TableStyle))]
public class TableStyles : OpenXmlCompositeElement

Hinweise

The following table lists the possible child types:

  • TableStyle <x:tableStyle>

[ISO/IEC 29500-1 1. Ausgabe]

18.8.42 tableStyles (Table Styles)

This element represents a collection of Table style definitions for Table styles and PivotTable styles used in this workbook. It consists of a sequence of tableStyle records, each defining a single Table style.

A Table style is a collection of formatting that applies to structured regions of a Table or PivotTable [Example: make the header row & totals bold face, and apply light gray fill to alternating rows in the data portion of the table to achieve striped or banded rows. end example]

See the enumeration values in ST_TableStyleType for a listing of structured Table regions to which formatting can be applied, and which together make up a single Table style definition.

Parent Elements

styleSheet (§18.8.39)

Child Elements

Subclause

tableStyle (Table Style)

§18.8.40

Attributes

Description

count (Table Style Count)

Count of table styles defined in this collection.

The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype.

defaultPivotStyle (Default Pivot Style)

Name of the default table style to apply to new PivotTables. This can be set by the user interface.

The possible values for this attribute are defined by the W3C XML Schema string datatype.

defaultTableStyle (Default Table Style)

Name of default table style to apply to new Tables. This can be set by the user interface.

The possible values for this attribute are defined by the W3C XML Schema string datatype.

[Note: The W3C XML Schema definition of this element's content model (CT_TableStyles) is located in §A.2. end note]

© ISO/IEC29500: 2008. Die oben aufgeführten Textauszüge wurden von Microsoft (und/oder den Microsoft-Vendoren) von Englisch nach Deutsch übersetzt, und im Rahmen von ISO wird keinerlei Verantwortung für diese Übersetzungen übernommen.

Threadsicherheit

Alle öffentlichen static (Shared in Visual Basic) Member dieses Typs sind threadsicher. Bei Instanzmembern ist die Threadsicherheit nicht gewährleistet.

Siehe auch

Referenz

TableStyles-Member

DocumentFormat.OpenXml.Spreadsheet-Namespace