Skip to content

Class ExcelTableAndPivotTableNamedStyle

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

A custom named table style that applies to both tables and pivot tables

public class ExcelTableAndPivotTableNamedStyle : ExcelPivotTableNamedStyle

Inheritance

object ← XmlHelper ← ExcelTableNamedStyleBase ← ExcelPivotTableNamedStyle ← ExcelTableAndPivotTableNamedStyle

Inherited Members

ExcelPivotTableNamedStyle.AppliesTo
ExcelPivotTableNamedStyle.BlankRow
ExcelPivotTableNamedStyle.FirstColumnSubheading
ExcelPivotTableNamedStyle.FirstRowSubheading
ExcelPivotTableNamedStyle.FirstSubtotalColumn
ExcelPivotTableNamedStyle.FirstSubtotalRow
ExcelPivotTableNamedStyle.PageFieldLabels
ExcelPivotTableNamedStyle.PageFieldValues
ExcelPivotTableNamedStyle.SecondColumnSubheading
ExcelPivotTableNamedStyle.SecondRowSubheading
ExcelPivotTableNamedStyle.SecondSubtotalColumn
ExcelPivotTableNamedStyle.SecondSubtotalRow
ExcelPivotTableNamedStyle.ThirdColumnSubheading
ExcelPivotTableNamedStyle.ThirdRowSubheading
ExcelPivotTableNamedStyle.ThirdSubtotalColumn
ExcelPivotTableNamedStyle.ThirdSubtotalRow
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

FirstTotalCell

Applies to the first total cell of a table

public ExcelTableStyleElement FirstTotalCell { get; }

Property Value

ExcelTableStyleElement

LastHeaderCell

Applies to the last header cell of a table

public ExcelTableStyleElement LastHeaderCell { get; }

Property Value

ExcelTableStyleElement

LastTotalCell

Applies to the last total cell of a table

public ExcelTableStyleElement LastTotalCell { get; }

Property Value

ExcelTableStyleElement