Click or drag to resize

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
)

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