The ShowValueAsType class contains the Excel value field show value as types supported by ExcelWriter.

 public sealed class ShowValueAsType
Public NotInheritable Class ShowValueAsType

Values labels will return ShowValueAsType.Normal. You can check if a PivotField is values label with the IsValuesLabel Property

Name

Description

Normal

Indicates that the field is shown as its normal data \type.

Difference

Indicates the field is shown as the "difference from" a \value.

Percent

Indicates the field is show as the "percentage of"

PercentDiff

Indicates the field is shown as the "percentage \difference from" a value.

RunningTotal

Indicates the field is shown as running total in the \table.

PercentRow

Indicates the field is shown as the percentage of row

PercentColumn

Indicates the field is shown as the percentage of \column.

PercentTotal

Indicates the field is shown as percentage of total.

Index

Indicates the field is shown as the index.