.
...
| Wiki Markup |
|---|
{introducedin: 8.4 |
...
| Description |
|---|
| Excerpt |
|---|
The |
| Signature | ||
|---|---|---|
| C# | C# | }
{description}
{excerpt}
The {{SummarizeByType}} class contains the Excel value field summarize by types supported by ExcelWriter.{excerpt}
{signature:C#} public sealed class SummarizeByType |
| Signature | ||
{signature}{signature:vb.net | vb.net | }Public NotInheritable Class SummarizeByType |
| Values |
|---|
...
Name
...
Description
...
The average of the values.
...
The number of data values. works the same as the COUNTA worksheet function.
...
The number of data values that are numbers. Works the same as the COUNT worksheet function.
...
The largest value.
...
The smallest value.
...
The product of the values.
...
An estimate of the standard deviation of a population,
where the sample is a subset of the entire population.
...
The standard deviation of a population, where the
population is all of the data to be summarized.
...
The sum of the values.
...
An estimate of the variance of a population, where the
sample is a subset of the entire population.
...
{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.| |