Page tree
Skip to end of metadata
Go to start of metadata

Introduced in build 8.4

Description

The SummarizeByType class contains the Excel value field summarize by types supported by ExcelWriter.

C#
vb.net

Values

Name

Description

Average

The average of the values.

Count

The number of data values. works the same as the COUNTA worksheet function.

CountNumbers

The number of data values that are numbers. Works the same as the COUNT worksheet function.

Max

The largest value.

Min

The smallest value.

Product

The product of the values.

StdDev

An estimate of the standard deviation of a population,
where the sample is a subset of the entire population.

StdDevp

The standard deviation of a population, where the
population is all of the data to be summarized.

Sum

The sum of the values.

Var

An estimate of the variance of a population, where the
sample is a subset of the entire population.

Varp

The variance of a population, where the population is
all of the data to be summarized.

  • No labels