subtotal method

subtotal

Creates subtotals for the range.

def subtotal(self, ca, group_by, function, total_list):
    ...
ParameterTypeDescription
caCellAreaThe range
group_byintThe field to group by, as a zero-based integer offset
functionConsolidationFunctionThe subtotal function.
total_listlistAn array of zero-based field offsets, indicating the fields to which the subtotals are added.

subtotal

Creates subtotals for the range.

def subtotal(self, ca, group_by, function, total_list, replace, page_breaks, summary_below_data):
    ...
ParameterTypeDescription
caCellAreaThe range
group_byintThe field to group by, as a zero-based integer offset
functionConsolidationFunctionThe 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