subtotal method
Contents
[
Hide
]subtotal(self, ca, group_by, function, total_list)
Creates subtotals for the range.
def subtotal(self, ca, group_by, function, total_list):
...
| Parameter | Type | Description |
|---|---|---|
| ca | aspose.cells.CellArea | The range |
| group_by | int | The field to group by, as a zero-based integer offset |
| function | aspose.cells.ConsolidationFunction | The subtotal function. |
| total_list | list | An array of zero-based field offsets, indicating the fields to which the subtotals are added. |
subtotal(self, ca, group_by, function, total_list, replace, page_breaks, summary_below_data)
Creates subtotals for the range.
def subtotal(self, ca, group_by, function, total_list, replace, page_breaks, summary_below_data):
...
| Parameter | Type | Description |
|---|---|---|
| ca | aspose.cells.CellArea | The range |
| group_by | int | The field to group by, as a zero-based integer offset |
| function | aspose.cells.ConsolidationFunction | The subtotal function. |
| total_list | list | An array of zero-based field offsets, indicating the fields to which the subtotals are added. |
| replace | bool | Indicates whether replace the current subtotals |
| page_breaks | bool | Indicates whether add page break between groups |
| summary_below_data | bool | Indicates whether add summary below data. |
See Also
- module
aspose.cells - class
Cells