Document Solutions for Excel, Java Edition | Document Solutions
com.grapecity.documents.excel Package / IRange Interface / subtotal Method / subtotal(int,ConsolidationFunction,int[],SummaryRow) Method
The field to group by, as a one-based integer offset.
The subtotal function.
An array of 1-based field offsets, indicating the fields to which the subtotals are added.
Places the summary data relative to the subtotal. The default value is Below.
In This Topic
    subtotal(int,ConsolidationFunction,int[],SummaryRow) Method
    In This Topic
    Creates subtotals for the range.
    Syntax

    Parameters

    groupBy
    The field to group by, as a one-based integer offset.
    subtotalFunction
    The subtotal function.
    totalList
    An array of 1-based field offsets, indicating the fields to which the subtotals are added.
    summaryRowLocation
    Places the summary data relative to the subtotal. The default value is Below.
    See Also