PivotTableStyle-Klasse
PivotTable Style.When the object is serialized out as xml, its qualified name is x:pivotTableStyleInfo.
Vererbungshierarchie
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
Hinweise
[ISO/IEC 29500-1 1. Ausgabe]
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. 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.