XlsWorksheet
Subtotal Method (IXLSRange, Int32,
Int32
, SubtotalTypes, Boolean, Boolean, Boolean)
|
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,
bool replace,
bool addPageBreak,
bool addsummaryBelowData
)
Public Sub Subtotal (
range As IXLSRange,
groupByIndex As Integer,
totalFields As Integer(),
subtotalType As SubtotalTypes,
replace As Boolean,
addPageBreak As Boolean,
addsummaryBelowData As Boolean
)
public:
void Subtotal(
IXLSRange^ range,
int groupByIndex,
array<int>^ totalFields,
SubtotalTypes subtotalType,
bool replace,
bool addPageBreak,
bool addsummaryBelowData
)
member Subtotal :
range : IXLSRange *
groupByIndex : int *
totalFields : int[] *
subtotalType : SubtotalTypes *
replace : bool *
addPageBreak : bool *
addsummaryBelowData : bool -> 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.
-
replace
-
Type:
System
Boolean
Indicates whether replace the current subtotals
-
addPageBreak
-
Type:
System
Boolean
Indicates whether add page break between groups
-
addsummaryBelowData
-
Type:
System
Boolean
Indicates whether add summarry below data.
See Also