Page History

...

Introducedin

	8.4

...


	8.4

Description

Excerpt
The `ShowValueAs` class contains the options for showing the value of a DataField. It is equivalent to the Show Values As tab in DataField settings in Excel.

Signature

	C#
	C#

public sealed class ShowValueAs
{signature}{signature:

}

Signature

	vb.net


	vb.net

Public NotInheritable Class ShowValueAs
{signature}

{example}{code:csharp|title=C#}

Example

Code Block

	csharp
	csharp
title	C#



          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Open("template.xlsx");
          ShowValueAs options = wb[0].PivotTables[0].DataFields[0].ShowValueAs;

{code} {code:vbnet|title=

Code Block

	vbnet
	vbnet
title	vb.net

}



          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Open("template.xlsx")
          Dim options As ShowValueAs = wb(0).PivotTables(0).DataFields(0).ShowValueAs;

{code} {example} {properties} || Name || Description || | [BaseField|ShowValueAs.BaseField] | {excerpt-include:ShowValueAs.BaseField|nopanel=true} | | [BaseIndex|ShowValueAs.BaseIndex] | {excerpt-include:ShowValueAs.BaseIndex|nopanel=true} | | [BaseItemNext|EW8:ShowValueAs.BaseItemNext] | {excerpt-include:ShowValueAs.BaseItemNext|nopanel=true} | | [BaseItemPrevious|EW8:ShowValueAs.BaseItemPrevious] | {excerpt-include:ShowValueAs.BaseItemPrevious|nopanel=true} | | [ShowValueAsType|ShowValueAs.ShowValueAsType] | {excerpt-include:ShowValueAs.ShowValueAsType|nopanel=true} | | [ValueType|ShowValueAs.ValueType] | {excerpt-include:ShowValueAs.ValueType|nopanel=true} | {methods} || Name || Description || | [SetShowValueAs()|EW8:ShowValueAs.SetShowValueAs (ShowValueAsType, SourceField, Int32)] | {excerpt-include:ShowValueAs.SetShowValueAs (ShowValueAsType, SourceField, Int32)|nopanel=true} |

Properties

Name

Description

BaseField

Excerpt Include

	ShowValueAs.BaseField
	ShowValueAs.BaseField
nopanel	true

BaseIndex

Excerpt Include

	ShowValueAs.BaseIndex
	ShowValueAs.BaseIndex
nopanel	true

BaseItemNext

Excerpt Include

	ShowValueAs.BaseItemNext
	ShowValueAs.BaseItemNext
nopanel	true

BaseItemPrevious

Excerpt Include

	ShowValueAs.BaseItemPrevious
	ShowValueAs.BaseItemPrevious
nopanel	true

ShowValueAsType

Excerpt Include

	ShowValueAs.ShowValueAsType
	ShowValueAs.ShowValueAsType
nopanel	true

ValueType

Excerpt Include

	ShowValueAs.ValueType
	ShowValueAs.ValueType
nopanel	true

Methods

Name

Description

SetShowValueAs()

Excerpt Include

	ShowValueAs.SetShowValueAs (ShowValueAsType, SourceField, Int32)
	ShowValueAs.SetShowValueAs (ShowValueAsType, SourceField, Int32)
nopanel	true

Space Shortcuts

Page tree

Versions Compared

Old Version 12

New Version Current

Key