add method
Contents
[
Hide
]add
Add a new Slicer using PivotTable as data source
Returns
The new add Slicer index
def add(self, pivot, dest_cell_name, base_field_name):
...
| Parameter | Type | Description |
|---|---|---|
| pivot | aspose.cells.pivot.PivotTable | PivotTable object |
| dest_cell_name | str | The cell in the upper-left corner of the Slicer range. |
| base_field_name | str | The name of PivotField in PivotTable.BaseFields |
Example
slicers.add(pivot, "E3", "fruit")
add
Add a new Slicer using PivotTable as data source
Returns
The new add Slicer index
def add(self, pivot, dest_cell_name, base_field_index):
...
| Parameter | Type | Description |
|---|---|---|
| pivot | aspose.cells.pivot.PivotTable | PivotTable object |
| dest_cell_name | str | The cell in the upper-left corner of the Slicer range. |
| base_field_index | int | The index of PivotField in PivotTable.BaseFields |
Example
slicers.add(pivot, "E20", 0)
add
Add a new Slicer using PivotTable as data source
Returns
The new add Slicer index
def add(self, pivot, dest_cell_name, base_field):
...
| Parameter | Type | Description |
|---|---|---|
| pivot | aspose.cells.pivot.PivotTable | PivotTable object |
| dest_cell_name | str | The cell in the upper-left corner of the Slicer range. |
| base_field | aspose.cells.pivot.PivotField | The PivotField in PivotTable.BaseFields |
Example
slicers.add(pivot, "I3", pivot.base_fields[0])
add
Add a new Slicer using ListObjet as data source
Returns
The new add Slicer index
def add(self, table, index, dest_cell_name):
...
| Parameter | Type | Description |
|---|---|---|
| table | aspose.cells.tables.ListObject | ListObject object |
| index | int | The index of ListColumn in ListObject.ListColumns |
| dest_cell_name | str | The cell in the upper-left corner of the Slicer range. |
Example
slicers.add(table, 1, "E38")
add
Add a new Slicer using ListObjet as data source
Returns
The new add Slicer index
def add(self, table, list_column, dest_cell_name):
...
| Parameter | Type | Description |
|---|---|---|
| table | aspose.cells.tables.ListObject | ListObject object |
| list_column | aspose.cells.tables.ListColumn | The ListColumn in ListObject.ListColumns |
| dest_cell_name | str | The cell in the upper-left corner of the Slicer range. |
Example
slicers.add(table, table.list_columns[1], "I38")
add
Add a new Slicer using PivotTable as data source
Returns
The new add Slicer index
def add(self, pivot, row, column, base_field_name):
...
| Parameter | Type | Description |
|---|---|---|
| pivot | aspose.cells.pivot.PivotTable | PivotTable object |
| row | int | Row index of the cell in the upper-left corner of the Slicer range. |
| column | int | Column index of the cell in the upper-left corner of the Slicer range. |
| base_field_name | str | The name of PivotField in PivotTable.BaseFields |
Example
slicers.add(pivot, 20, 12, "fruit")
add
Add a new Slicer using PivotTable as data source
Returns
The new add Slicer index
def add(self, pivot, row, column, base_field_index):
...
| Parameter | Type | Description |
|---|---|---|
| pivot | aspose.cells.pivot.PivotTable | PivotTable object |
| row | int | Row index of the cell in the upper-left corner of the Slicer range. |
| column | int | Column index of the cell in the upper-left corner of the Slicer range. |
| base_field_index | int | The index of PivotField in PivotTable.BaseFields |
Example
slicers.add(pivot, 20, 8, 0)
add
Add a new Slicer using PivotTable as data source
Returns
The new add Slicer index
def add(self, pivot, row, column, base_field):
...
| Parameter | Type | Description |
|---|---|---|
| pivot | aspose.cells.pivot.PivotTable | PivotTable object |
| row | int | Row index of the cell in the upper-left corner of the Slicer range. |
| column | int | Column index of the cell in the upper-left corner of the Slicer range. |
| base_field | aspose.cells.pivot.PivotField | The PivotField in PivotTable.BaseFields |
Example
slicers.add(pivot, 3, 12, pivot.base_fields[0])
add
Add a new Slicer using ListObjet as data source
Returns
The new add Slicer index
def add(self, table, list_column, row, column):
...
| Parameter | Type | Description |
|---|---|---|
| table | aspose.cells.tables.ListObject | ListObject object |
| list_column | aspose.cells.tables.ListColumn | The ListColumn in ListObject.ListColumns |
| row | int | Row index of the cell in the upper-left corner of the Slicer range. |
| column | int | Column index of the cell in the upper-left corner of the Slicer range. |
Example
slicers.add(table, table.list_columns[1], 38, 12)
See Also
- module
aspose.cells.slicers - class
SlicerCollection
