XlsWorksheet
Subtotal Method (IXLSRange, Int32,
Int32
, SubtotalTypes)
|
Creates subtotals for the range.
Namespace:
Spire.Xls.Core.Spreadsheet
Assembly:
Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public void Subtotal(
IXLSRange range,
int groupByIndex,
int[] totalFields,
SubtotalTypes subtotalType
)
Public Sub Subtotal (
range As IXLSRange,
groupByIndex As Integer,
totalFields As Integer(),
subtotalType As SubtotalTypes
)
public:
void Subtotal(
IXLSRange^ range,
int groupByIndex,
array<int>^ totalFields,
SubtotalTypes subtotalType
)
member Subtotal :
range : IXLSRange *
groupByIndex : int *
totalFields : int[] *
subtotalType : SubtotalTypes -> unit
Parameters
-
range
-
Type:
Spire.Xls.Core
IXLSRange
The range
-
groupByIndex
-
Type:
System
Int32
The field index to group by, offset from zero
-
totalFields
-
Type:
System
Int32
An array of zero-based field index offsets, indicating the fields to which the subtotals are added.
-
subtotalType
-
Type:
Spire.Xls
SubtotalTypes
The subtotal type.
See Also