Partager via


XmlMappedRange.Subtotal Method

Creates subtotals for the XmlMappedRange control.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
Function Subtotal ( _
    GroupBy As Integer, _
    Function As XlConsolidationFunction, _
    TotalList As Object, _
    Replace As Object, _
    PageBreaks As Object, _
    SummaryBelowData As XlSummaryRow _
) As Object
Object Subtotal(
    int GroupBy,
    XlConsolidationFunction Function,
    Object TotalList,
    Object Replace,
    Object PageBreaks,
    XlSummaryRow SummaryBelowData
)

Parameters

  • GroupBy
    Type: System.Int32

    The field to group by, as a one-based integer offset.

  • TotalList
    Type: System.Object

    An array of 1-based field offsets, indicating the fields to which the subtotals are added.

  • Replace
    Type: System.Object

    true to replace existing subtotals. The default value is false.

  • PageBreaks
    Type: System.Object

    true to add page breaks after each group. The default value is false.

Return Value

Type: System.Object

Remarks

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

.NET Framework Security

See Also

Reference

XmlMappedRange Interface

Microsoft.Office.Tools.Excel Namespace