OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 3

changes.mady.by.user Unknown User (ingridh)

Saved on

compared with

New Version Current

changes.mady.by.user Alison Bird [softartisans]

Saved on

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.34
8.34
Description

Excerpt

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

...

Signature
vb.net
vb.net
Public NotInheritable Class SummarizeByType
Values

...

Name

...

Description

...

Anchor
Average
Average
Average Average

The average of the values.

Anchor
Count
Count
Count Count

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

Anchor
CountNumbers
CountNumbers
CountNumbers Count Numbers

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

Anchor
Max
Max
Max Max

The largest value.

Anchor
Min
Min
Min Min

The smallest value.

Anchor
Product
Product
Product Product

The product of the values.

Anchor
StdDev
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

StdDevp

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

Anchor
Sum
Sum
Sum Sum

The sum of the values.

Anchor
Var
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

Varp

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