PivotFilter Class |
Namespace: Aspose.Cells.Pivot
The PivotFilter type exposes the following members.
Name | Description | |
---|---|---|
![]() | AutoFilter |
Gets the autofilter of the pivot filter.
|
![]() | EvaluationOrder |
Gets the Evaluation Order of the pivot filter.
|
![]() | FieldIndex |
Gets the field index of the pivot filter.
|
![]() | FilterType |
Gets the autofilter type of the pivot filter.
|
![]() | MeasureFldIndex |
Gets the measure field index of the pivot filter.
|
![]() | MemberPropertyFieldIndex |
Gets the member property field index of the pivot filter.
|
![]() | Name |
Gets the name of the pivot filter.
|
![]() | Value1 |
Gets the string value1 of the label pivot filter.
|
![]() | Value2 |
Gets the string value2 of the label pivot filter.
|
Name | Description | |
---|---|---|
![]() | Equals | (Inherited from Object.) |
![]() | Finalize | (Inherited from Object.) |
![]() | GetHashCode | (Inherited from Object.) |
![]() | GetType | (Inherited from Object.) |
![]() | MemberwiseClone | (Inherited from 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 PivotFilter int index = pivot.PivotFilters.Add(0, PivotFilterType.Count); PivotFilter filter = pivot.PivotFilters[index]; filter.AutoFilter.FilterTop10(0, false, false, 2); 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 PivotFilter Dim filterIndex As Int32 = pivot.PivotFilters.Add(0, PivotFilterType.Count) Dim filter As PivotFilter = pivot.PivotFilters(filterIndex) filter.AutoFilter.FilterTop10(0, False, False, 2) pivot.RefreshData() pivot.CalculateData() book.Save("out_vb.xlsx")