SlicerCollection Class |
Namespace: Aspose.Cells.Slicers
The SlicerCollection type exposes the following members.
Name | Description | |
---|---|---|
![]() | Capacity | (Inherited from CollectionBase.) |
![]() | Count | (Inherited from CollectionBase.) |
![]() | InnerList | (Inherited from CollectionBase.) |
![]() ![]() | ItemInt32 |
Gets the Slicer by index.
|
![]() ![]() | ItemString |
Gets the Slicer by slicer's name.
|
![]() | List | (Inherited from CollectionBase.) |
Name | Description | |
---|---|---|
![]() ![]() | Add(ListObject, ListColumn, String) |
Add a new Slicer using ListObjet as data source
|
![]() ![]() | Add(ListObject, Int32, String) |
Add a new Slicer using ListObjet as data source
|
![]() ![]() | Add(PivotTable, String, PivotField) |
Add a new Slicer using PivotTable as data source
|
![]() ![]() | Add(PivotTable, String, Int32) |
Add a new Slicer using PivotTable as data source
|
![]() ![]() | Add(PivotTable, String, String) |
Add a new Slicer using PivotTable as data source
|
![]() ![]() | Add(ListObject, ListColumn, Int32, Int32) |
Add a new Slicer using ListObjet as data source
|
![]() ![]() | Add(PivotTable, Int32, Int32, PivotField) |
Add a new Slicer using PivotTable as data source
|
![]() ![]() | Add(PivotTable, Int32, Int32, Int32) |
Add a new Slicer using PivotTable as data source
|
![]() ![]() | Add(PivotTable, Int32, Int32, String) |
Add a new Slicer using PivotTable as data source
|
![]() | Clear | (Inherited from CollectionBase.) |
![]() | Equals | (Inherited from Object.) |
![]() | Finalize | (Inherited from Object.) |
![]() | GetEnumerator | (Inherited from CollectionBase.) |
![]() | GetHashCode | (Inherited from Object.) |
![]() | GetType | (Inherited from Object.) |
![]() | MemberwiseClone | (Inherited from Object.) |
![]() | OnClear | (Inherited from CollectionBase.) |
![]() | OnClearComplete | (Inherited from CollectionBase.) |
![]() | OnInsert | (Inherited from CollectionBase.) |
![]() | OnInsertComplete | (Inherited from CollectionBase.) |
![]() | OnRemove | (Inherited from CollectionBase.) |
![]() | OnRemoveComplete | (Inherited from CollectionBase.) |
![]() | OnSet | (Inherited from CollectionBase.) |
![]() | OnSetComplete | (Inherited from CollectionBase.) |
![]() | OnValidate | (Inherited from CollectionBase.) |
![]() ![]() | Remove |
Remove the specified Slicer
|
![]() ![]() | RemoveAt |
Deletes the Slicer at the specified index
|
![]() | 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; pivot.RefreshData(); pivot.CalculateData(); SlicerCollection slicers = sheet.Slicers; int tableIndex = sheet.ListObjects.Add("A1", "C9", true); ListObject table = sheet.ListObjects[tableIndex]; //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 pivot.RefreshData() pivot.CalculateData() Dim slicers As SlicerCollection = sheet.Slicers Dim tableIndex As Int32 = sheet.ListObjects.Add("A1", "C9", True) Dim table As ListObject = sheet.ListObjects(tableIndex) book.Save("out_vb.xlsx")