PivotFormatCondition Class |
Namespace: Aspose.Cells.Pivot
The PivotFormatCondition type exposes the following members.
Name | Description | |
---|---|---|
![]() | FormatConditions |
Get formatconditions for the pivot table condition format .
|
![]() | RuleType |
Get and set rule type for the pivot table condition format .
|
![]() | ScopeType |
Get and set scope type for the pivot table condition format .
|
Name | Description | |
---|---|---|
![]() | AddColumnAreaCondition(String) |
Adds PivotTable conditional format limit in the column fields.
|
![]() | AddColumnAreaCondition(PivotField) |
Adds PivotTable conditional format limit in the column fields.
|
![]() | AddDataAreaCondition(String) |
Adds PivotTable conditional format limit in the data fields.
|
![]() | AddDataAreaCondition(PivotField) |
Adds PivotTable conditional format limit in the data fields.
|
![]() | AddRowAreaCondition(String) |
Adds PivotTable conditional format limit in the row fields.
|
![]() | AddRowAreaCondition(PivotField) |
Adds PivotTable conditional format limit in the row fields.
|
![]() | Equals | (Inherited from Object.) |
![]() | Finalize | (Inherited from Object.) |
![]() | GetHashCode | (Inherited from Object.) |
![]() | GetType | (Inherited from Object.) |
![]() | MemberwiseClone | (Inherited from Object.) |
![]() | SetConditionalAreas |
Sets conditional areas of PivotFormatCondition object.
|
![]() | ToString | (Inherited from Object.) |
[C#] Workbook book = new Workbook(); Worksheet sheet = book.Worksheets[0]; Cells cells = sheet.Cells; cells[0, 0].Value = "fruit"; cells[1, 0].Value = "grape"; cells[2, 0].Value = "blueberry"; cells[3, 0].Value = "kiwi"; cells[4, 0].Value = "cherry"; cells[5, 0].Value = "grape"; cells[6, 0].Value = "blueberry"; cells[7, 0].Value = "kiwi"; cells[8, 0].Value = "cherry"; cells[0, 1].Value = "year"; cells[1, 1].Value = 2020; cells[2, 1].Value = 2020; cells[3, 1].Value = 2020; cells[4, 1].Value = 2020; cells[5, 1].Value = 2021; cells[6, 1].Value = 2021; cells[7, 1].Value = 2021; cells[8, 1].Value = 2021; cells[0, 2].Value = "amount"; cells[1, 2].Value = 50; cells[2, 2].Value = 60; cells[3, 2].Value = 70; cells[4, 2].Value = 80; cells[5, 2].Value = 90; cells[6, 2].Value = 100; cells[7, 2].Value = 110; cells[8, 2].Value = 120; PivotTableCollection pivots = sheet.PivotTables; int pivotIndex = pivots.Add("=Sheet1!A1:C9", "A12", "TestPivotTable"); PivotTable pivot = pivots[pivotIndex]; pivot.AddFieldToArea(PivotFieldType.Row, "fruit"); pivot.AddFieldToArea(PivotFieldType.Column, "year"); pivot.AddFieldToArea(PivotFieldType.Data, "amount"); pivot.PivotTableStyleType = PivotTableStyleType.PivotTableStyleMedium10; //Add PivotFormatCondition int formatIndex = pivot.PivotFormatConditions.Add(); PivotFormatCondition pfc = pivot.PivotFormatConditions[formatIndex]; FormatConditionCollection fcc = pfc.FormatConditions; fcc.AddArea(pivot.DataBodyRange); int idx = fcc.AddCondition(FormatConditionType.CellValue); FormatCondition fc = fcc[idx]; fc.Formula1 = "100"; fc.Operator = OperatorType.GreaterOrEqual; fc.Style.BackgroundColor = Color.Red; pivot.RefreshData(); pivot.CalculateData(); //do your business book.Save("out.xlsx"); [Visual Basic] Dim book As Workbook = New Workbook() Dim sheet As Worksheet = book.Worksheets(0) Dim cells As Cells = sheet.Cells cells(0, 0).Value = "fruit" cells(1, 0).Value = "grape" cells(2, 0).Value = "blueberry" cells(3, 0).Value = "kiwi" cells(4, 0).Value = "cherry" cells(5, 0).Value = "grape" cells(6, 0).Value = "blueberry" cells(7, 0).Value = "kiwi" cells(8, 0).Value = "cherry" cells(0, 1).Value = "year" cells(1, 1).Value = 2020 cells(2, 1).Value = 2020 cells(3, 1).Value = 2020 cells(4, 1).Value = 2020 cells(5, 1).Value = 2021 cells(6, 1).Value = 2021 cells(7, 1).Value = 2021 cells(8, 1).Value = 2021 cells(0, 2).Value = "amount" cells(1, 2).Value = 50 cells(2, 2).Value = 60 cells(3, 2).Value = 70 cells(4, 2).Value = 80 cells(5, 2).Value = 90 cells(6, 2).Value = 100 cells(7, 2).Value = 110 cells(8, 2).Value = 120 Dim pivots As PivotTableCollection = sheet.PivotTables Dim pivotIndex As Int32 = pivots.Add("=Sheet1!A1:C9", "A12", "TestPivotTable") Dim pivot As PivotTable = pivots(pivotIndex) pivot.AddFieldToArea(PivotFieldType.Row, "fruit") Pivot.AddFieldToArea(PivotFieldType.Column, "year") Pivot.AddFieldToArea(PivotFieldType.Data, "amount") pivot.PivotTableStyleType = PivotTableStyleType.PivotTableStyleMedium10 'Add PivotFormatCondition Dim formatIndex As Int32 = pivot.PivotFormatConditions.Add() Dim pfc As PivotFormatCondition = pivot.PivotFormatConditions(formatIndex) Dim fcc As FormatConditionCollection = pfc.FormatConditions fcc.AddArea(pivot.DataBodyRange) Dim idx As Int32 = fcc.AddCondition(FormatConditionType.CellValue) Dim fc As FormatCondition = fcc(idx) fc.Formula1 = "100" fc.Operator = OperatorType.GreaterOrEqual fc.Style.BackgroundColor = Color.Red pivot.RefreshData() pivot.CalculateData() book.Save("out_vb.xlsx")