Class ExcelPivotTableNamedStyle¶

Namespace: OfficeOpenXml.Style.Table
Assembly: EPPlus.dll

A custom named table style that applies to pivot tables only

public class ExcelPivotTableNamedStyle : ExcelTableNamedStyleBase

Inheritance¶

object ← XmlHelper ← ExcelTableNamedStyleBase ← ExcelPivotTableNamedStyle

Derived¶

ExcelTableAndPivotTableNamedStyle

Inherited Members¶

ExcelTableNamedStyleBase.AppliesTo
ExcelTableNamedStyleBase.As
ExcelTableNamedStyleBase.FirstColumn
ExcelTableNamedStyleBase.FirstColumnStripe
ExcelTableNamedStyleBase.FirstHeaderCell
ExcelTableNamedStyleBase.FirstRowStripe
ExcelTableNamedStyleBase.HeaderRow
ExcelTableNamedStyleBase.LastColumn
ExcelTableNamedStyleBase.Name
ExcelTableNamedStyleBase.SecondColumnStripe
ExcelTableNamedStyleBase.SecondRowStripe
ExcelTableNamedStyleBase.TotalRow
ExcelTableNamedStyleBase.WholeTable
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Properties¶

AppliesTo¶

If the style applies to tables, pivot table or both

public override eTableNamedStyleAppliesTo AppliesTo { get; }

Property Value¶

eTableNamedStyleAppliesTo

BlankRow¶

Applies to blank rows of a pivot table

public ExcelTableStyleElement BlankRow { get; }

Property Value¶

ExcelTableStyleElement

FirstColumnSubheading¶

Applies to the first column subheading of a pivot table

public ExcelTableStyleElement FirstColumnSubheading { get; }

Property Value¶

ExcelTableStyleElement

FirstRowSubheading¶

Applies to the first row subheading of a pivot table

public ExcelTableStyleElement FirstRowSubheading { get; }

Property Value¶

ExcelTableStyleElement

FirstSubtotalColumn¶

Applies to the first subtotal column of a pivot table

public ExcelTableStyleElement FirstSubtotalColumn { get; }

Property Value¶

ExcelTableStyleElement

FirstSubtotalRow¶

Applies to the first subtotal row of a pivot table

public ExcelTableStyleElement FirstSubtotalRow { get; }

Property Value¶

ExcelTableStyleElement

PageFieldLabels¶

Applies to the page field labels of a pivot table

public ExcelTableStyleElement PageFieldLabels { get; }

Property Value¶

ExcelTableStyleElement

PageFieldValues¶

Applies to the page field values of a pivot table

public ExcelTableStyleElement PageFieldValues { get; }

Property Value¶

ExcelTableStyleElement

SecondColumnSubheading¶

Applies to the second column subheading of a pivot table

public ExcelTableStyleElement SecondColumnSubheading { get; }

Property Value¶

ExcelTableStyleElement

SecondRowSubheading¶

Applies to the second row subheading of a pivot table

public ExcelTableStyleElement SecondRowSubheading { get; }

Property Value¶

ExcelTableStyleElement

SecondSubtotalColumn¶

Applies to the second subtotal column of a pivot table

public ExcelTableStyleElement SecondSubtotalColumn { get; }

Property Value¶

ExcelTableStyleElement

SecondSubtotalRow¶

Applies to the second subtotal row of a pivot table

public ExcelTableStyleElement SecondSubtotalRow { get; }

Property Value¶

ExcelTableStyleElement

ThirdColumnSubheading¶

Applies to the third column subheading of a pivot table

public ExcelTableStyleElement ThirdColumnSubheading { get; }

Property Value¶

ExcelTableStyleElement

ThirdRowSubheading¶

Applies to the third row subheading of a pivot table

public ExcelTableStyleElement ThirdRowSubheading { get; }

Property Value¶

ExcelTableStyleElement

ThirdSubtotalColumn¶

Applies to the third subtotal column of a pivot table

public ExcelTableStyleElement ThirdSubtotalColumn { get; }

Property Value¶

ExcelTableStyleElement

ThirdSubtotalRow¶

Applies to the third subtotal row of a pivot table

public ExcelTableStyleElement ThirdSubtotalRow { get; }

Property Value¶

ExcelTableStyleElement