Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Introducedin
8.4

...

8.4
Description

Excerpt

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

Signature
C#
C#
 public sealed class SummarizeByType{signature}{signature:
}
Signature
vb.net
vb.net
Public NotInheritable Class SummarizeByType{signature}
{values}

|| Name || Description ||
| {anchor:Average}Average | The average of the values.|
| {anchor:Count}Count | The number of data values. works the same as the COUNTA worksheet function.|
| {anchor:CountNumbers}CountNumbers | The number of data values that are numbers. Works the same as the COUNT worksheet function. |
| {anchor:Max}Max | The largest value.|
| {anchor:Min}Min | The smallest value.|
| {anchor:Product}Product | The product of the values.|
| {anchor:StdDev}StdDev | An estimate of the standard deviation of a population,
where the sample is a subset of the entire population. |
| {anchor:StdDevp}StdDevp | The standard deviation of a population, where the
population is all of the data to be summarized.|
| {anchor:Sum}Sum | The sum of the values.|
| {anchor:Var}Var | An estimate of the variance of a population, where the
sample is a subset of the entire population.|
| {anchor:Varp}Varp | The variance of a population, where the population is
all of the data to be summarized.|
Values

Name

Description

Anchor
Average
Average
Average

The average of the values.

Anchor
Count
Count
Count

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

Anchor
CountNumbers
CountNumbers
CountNumbers

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

Anchor
Max
Max
Max

The largest value.

Anchor
Min
Min
Min

The smallest value.

Anchor
Product
Product
Product

The product of the values.

Anchor
StdDev
StdDev
StdDev

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

Anchor
StdDevp
StdDevp
StdDevp

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

Anchor
Sum
Sum
Sum

The sum of the values.

Anchor
Var
Var
Var

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

Anchor
Varp
Varp
Varp

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