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.