Class ExcelPivotTableAreaStyleCollection¶
Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll
A collection of pivot areas used for styling a pivot table.
public class ExcelPivotTableAreaStyleCollection : EPPlusReadOnlyList<ExcelPivotTableAreaStyle>, IEnumerable<ExcelPivotTableAreaStyle>, IEnumerable
Inheritance¶
object ← EPPlusReadOnlyList<ExcelPivotTableAreaStyle> ← ExcelPivotTableAreaStyleCollection
Implements¶
IEnumerable
IEnumerable<ExcelPivotTableAreaStyle>
Inherited Members¶
EPPlusReadOnlyList<ExcelPivotTableAreaStyle>.Count
EPPlusReadOnlyList<ExcelPivotTableAreaStyle>.GetIndexByValue(ExcelPivotTableAreaStyle)
EPPlusReadOnlyList<ExcelPivotTableAreaStyle>.this[int]
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()
Methods¶
Add()¶
Adds a pivot area style for labels or data.
Returns¶
AddAllData()¶
Adds a pivot area style that affects all data cells
Returns¶
The style object used to set the styles
AddAllLabels()¶
Adds a pivot area style that affects all labels
Returns¶
The style object used to set the styles
AddButtonField(ExcelPivotTableField)¶
Adds a style for the filter box.
Parameters¶
field ExcelPivotTableField
The field with the box to style
Returns¶
AddButtonField(ePivotTableAxis, int)¶
Adds a style for filter boxes.
Parameters¶
axis ePivotTableAxis
The axis for the field buttons
index int
The zero-based index in the axis collection
Returns¶
AddData(params ExcelPivotTableField[])¶
Adds a style for the data area of a pivot table
Parameters¶
fields ExcelPivotTableField[]
Returns¶
AddLabel(params ExcelPivotTableField[])¶
Adds a style for the labels of a pivot table
Parameters¶
fields ExcelPivotTableField[]
The pivot table field that style affects
Returns¶
AddTopEnd()¶
Adds a pivot area style for the top right cells of the pivot table, to the right of any filter button, if reading order i set to Left-To-Right.
Returns¶
AddTopEnd(string)¶
Adds a style for the top right cells of the pivot table, to the right of any filter button, if reading order i set to Left-To-Right.
Parameters¶
offsetAddress string
Offset address from the top-left cell to the right of any filter button. The top-left cell is refereced as A1. For example, B1:C1 will reference the second and third cell of the first row of the area. "null" will mean all cells
Returns¶
AddTopStart(string)¶
Adds a style for the top left cells of the pivot table, if reading order i set to Left-To-Right
Parameters¶
offsetAddress string
Offset address from the left cell. The top-left cell is refereced as A1. For example, B1:C1 will reference the second and third cell of the first row of the area. "null" will mean all cells
Returns¶
AddWholeTable()¶
Adds a pivot area style that affects the whole table.
Returns¶
The style object used to set the styles