XmlMappedRange.Subtotal Method

Article
01/07/2014

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.

Function
Type: Microsoft.Office.Interop.Excel.XlConsolidationFunction

The subtotal function.

Can be one of the following XlConsolidationFunction values:

xlAverage

xlCount

xlCountNums

xlMax

xlMin

xlProduct

xlStDev

xlStDevP

xlSum

xlUnknown

xlVar

xlVarP

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.

SummaryBelowData
Type: Microsoft.Office.Interop.Excel.XlSummaryRow

Places the summary data relative to the subtotal.

Can be one of the following XlSummaryRow values:

xlSummaryAbove

xlSummaryBelow (default)

Return Value

Type: System.Object

Remarks

Optional Parameters

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

.NET Framework Security

Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

Partager via