Compartilhar via


PivotTableStyle Class

PivotTable Style.When the object is serialized out as xml, its qualified name is x:pivotTableStyleInfo.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlLeafElement
      DocumentFormat.OpenXml.Spreadsheet.PivotTableStyle

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

Syntax

'Declaration
Public Class PivotTableStyle _
    Inherits OpenXmlLeafElement
'Usage
Dim instance As PivotTableStyle
public class PivotTableStyle : OpenXmlLeafElement

Remarks

[ISO/IEC 29500-1 1st Edition]

18.10.1.74 pivotTableStyleInfo (PivotTable Style)

Represent information on style applied to the PivotTable.

[Example:

<sh:pivotTableStyleInfo name="PivotStyleLight16" showRowHeaders="1"
showColHeaders="1" showRowStripes="0" showColStripes="0" showLastColumn="1"/>

end example]

Parent Elements

pivotTableDefinition (§18.10.1.73)

Attributes

Description

name (Table Style Name)

Specifies the name of the table style to use with this table.

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

showColHeaders (Show Table Style Column Header Formatting)

Specifies a boolean value that indicates whether to show column headers for the table.

A value of 1 or true indicates column headers are shown.

A value of 0 or false indicates column headers are omitted.

'True' if table style column header formatting should be displayed.

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

showColStripes (Show Column Stripes)

Specifies a boolean value that indicates whether to show column stripe formatting for the table.

A value of 1 or true indicates column stripe formatting is shown.

A value of 0 or false indicates no column formatting is shown.

True if table style column stripe formatting should be displayed.

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

showLastColumn (Show Last Column)

Specifies a boolean value that indicates whether to show the last column.

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

showRowHeaders (Show Row Header Formatting)

Specifies a boolean value that indicates whether to show row headers for the table.

A value of 1 or true indicates table style formatting is displayed.

A value of 0 or false indicates table style formatting will not be displayed.

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

showRowStripes (Show Row Stripes)

Specifies a boolean value that indicates whether to show row stripe formatting for the table.

A value of 1 or true indicates row stripe formatting is displayed.

A value of 0 or false indicates no row formatting is shown.

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

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

© ISO/IEC29500: 2008.

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

PivotTableStyle Members

DocumentFormat.OpenXml.Spreadsheet Namespace