Class ExcelPivotTableNamedStyle

A custom named table style that applies to pivot tables only

Inheritance
System.Object
XmlHelper
ExcelTableNamedStyleBase
ExcelPivotTableNamedStyle
ExcelTableAndPivotTableNamedStyle
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml.Style.Table
Assembly: EPPlus.dll
Syntax
public class ExcelPivotTableNamedStyle : ExcelTableNamedStyleBase

Properties

AppliesTo

If the style applies to tables, pivot table or both

Declaration
public override eTableNamedStyleAppliesTo AppliesTo { get; }
Property Value
Type Description
eTableNamedStyleAppliesTo
Overrides

BlankRow

Applies to blank rows of a pivot table

Declaration
public ExcelTableStyleElement BlankRow { get; }
Property Value
Type Description
ExcelTableStyleElement

FirstColumnSubheading

Applies to the first column subheading of a pivot table

Declaration
public ExcelTableStyleElement FirstColumnSubheading { get; }
Property Value
Type Description
ExcelTableStyleElement

FirstRowSubheading

Applies to the first row subheading of a pivot table

Declaration
public ExcelTableStyleElement FirstRowSubheading { get; }
Property Value
Type Description
ExcelTableStyleElement

FirstSubtotalColumn

Applies to the first subtotal column of a pivot table

Declaration
public ExcelTableStyleElement FirstSubtotalColumn { get; }
Property Value
Type Description
ExcelTableStyleElement

FirstSubtotalRow

Applies to the first subtotal row of a pivot table

Declaration
public ExcelTableStyleElement FirstSubtotalRow { get; }
Property Value
Type Description
ExcelTableStyleElement

PageFieldLabels

Applies to the page field labels of a pivot table

Declaration
public ExcelTableStyleElement PageFieldLabels { get; }
Property Value
Type Description
ExcelTableStyleElement

PageFieldValues

Applies to the page field values of a pivot table

Declaration
public ExcelTableStyleElement PageFieldValues { get; }
Property Value
Type Description
ExcelTableStyleElement

SecondColumnSubheading

Applies to the second column subheading of a pivot table

Declaration
public ExcelTableStyleElement SecondColumnSubheading { get; }
Property Value
Type Description
ExcelTableStyleElement

SecondRowSubheading

Applies to the second row subheading of a pivot table

Declaration
public ExcelTableStyleElement SecondRowSubheading { get; }
Property Value
Type Description
ExcelTableStyleElement

SecondSubtotalColumn

Applies to the second subtotal column of a pivot table

Declaration
public ExcelTableStyleElement SecondSubtotalColumn { get; }
Property Value
Type Description
ExcelTableStyleElement

SecondSubtotalRow

Applies to the second subtotal row of a pivot table

Declaration
public ExcelTableStyleElement SecondSubtotalRow { get; }
Property Value
Type Description
ExcelTableStyleElement

ThirdColumnSubheading

Applies to the third column subheading of a pivot table

Declaration
public ExcelTableStyleElement ThirdColumnSubheading { get; }
Property Value
Type Description
ExcelTableStyleElement

ThirdRowSubheading

Applies to the third row subheading of a pivot table

Declaration
public ExcelTableStyleElement ThirdRowSubheading { get; }
Property Value
Type Description
ExcelTableStyleElement

ThirdSubtotalColumn

Applies to the third subtotal column of a pivot table

Declaration
public ExcelTableStyleElement ThirdSubtotalColumn { get; }
Property Value
Type Description
ExcelTableStyleElement

ThirdSubtotalRow

Applies to the third subtotal row of a pivot table

Declaration
public ExcelTableStyleElement ThirdSubtotalRow { get; }
Property Value
Type Description
ExcelTableStyleElement