Online Documentation for Advanced Data Export .NET

XlsFieldFormat.Aggregate

public enum XlsAggregate

{

 aggNone,

 aggSum,

 aggAvg,

 aggMin,

 aggMax

}

public SqlManager.QExport.XLS.XlsAggregate Aggregate

Description

Use Aggregate to add an aggragate function to the cell below the column. The following values are available: aggNone - no function, aggSum - sum of the column values, aggAvg - average column value, aggMin - minimum value of the column, and aggMax - maximum value of the column. The default value is aggNone.