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.Name

ExcelTableNamedStyleBase.WholeTable

ExcelTableNamedStyleBase.FirstColumnStripe

ExcelTableNamedStyleBase.SecondColumnStripe

ExcelTableNamedStyleBase.FirstRowStripe

ExcelTableNamedStyleBase.SecondRowStripe

ExcelTableNamedStyleBase.LastColumn

ExcelTableNamedStyleBase.FirstColumn

ExcelTableNamedStyleBase.HeaderRow

ExcelTableNamedStyleBase.TotalRow

ExcelTableNamedStyleBase.FirstHeaderCell

ExcelTableNamedStyleBase.As

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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