.
...
| Wiki Markup |
|---|
{introducedin: 8.4 |
...
| Description |
|---|
| Excerpt |
|---|
The ShowValueAsType class contains the Excel value field show value as types supported by ExcelWriter. |
| Signature | ||
|---|---|---|
| C# | C# | }
{description}
{excerpt}
The ShowValueAsType class contains the Excel value field show value as types supported by ExcelWriter.{excerpt}
{signature:C#} public sealed class ShowValueAsType |
| Signature | ||
{signature}{signature:vb.net | vb.net | }Public NotInheritable Class ShowValueAsType |
| Remarks | ||
Values labels will return {signature} {remarks}Values labels will return ShowValueAsType.Normal. You can check if a PivotField is values label with the [IsValuesLabelProperty |
| Values |
|---|
...
Name
...
Description
...
Indicates that the field is shown as its normal data \type.
...
Indicates the field is shown as the "difference from" a \value.
...
Indicates the field is show as the "percentage of"
...
Indicates the field is shown as the "percentage \difference from" a value.
...
Indicates the field is shown as running total in the \table.
...
Indicates the field is shown as the percentage of row
...
Indicates the field is shown as the percentage of \column.
...
Indicates the field is shown as percentage of total.
...
|EW8:PivotTableField.IsValuesLabel]Property
{remarks}
{values}
|| Name || Description ||
| {anchor:Normal}Normal | Indicates that the field is shown as its normal data \type. |
| {anchor:Difference}Difference | Indicates the field is shown as the "difference from" a \value. |
| {anchor:Percent}Percent | Indicates the field is show as the "percentage of" |
| {anchor:PercentDiff} PercentDiff | Indicates the field is shown as the "percentage \difference from" a value. |
| {anchor:RunningTotal}RunningTotal | Indicates the field is shown as running total in the \table. |
| {anchor:PercentRow}PercentRow | Indicates the field is shown as the percentage of row |
| {anchor:PercentColumn}PercentColumn | Indicates the field is shown as the percentage of \column. |
| {anchor:PercentTotal}PercentTotal | Indicates the field is shown as percentage of total. |
| {anchor:Index}Index | Indicates the field is shown as the index. | |