subtotal method

subtotal(self, ca, group_by, function, total_list)

Creates subtotals for the range.


def subtotal(self, ca, group_by, function, total_list):
    ...
ParameterTypeDescription
caaspose.cells.CellAreaThe range
group_byintThe field to group by, as a zero-based integer offset
functionaspose.cells.ConsolidationFunctionThe subtotal function.
total_listlistAn 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):
    ...
ParameterTypeDescription
caaspose.cells.CellAreaThe range
group_byintThe field to group by, as a zero-based integer offset
functionaspose.cells.ConsolidationFunctionThe subtotal function.
total_listlistAn array of zero-based field offsets, indicating the fields to which the subtotals are added.
replaceboolIndicates whether replace the current subtotals
page_breaksboolIndicates whether add page break between groups
summary_below_databoolIndicates whether add summary below data.

See Also