Wiki Markup |
---|
{introducedin: 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.{excerpt} {signature:C#} public sealed class ShowValueAs {signature}{signature:vb.net} Public NotInheritable Class ShowValueAs {signature} {example}{code: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=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} | |
Page History
Overview
Content Tools