OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 2

changes.mady.by.user Unknown User (ingridh)

Saved on

compared with

New Version 3

changes.mady.by.user Unknown User (ingridh)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Description

Excerpt

Sets the ShowValueAs properties of a pivot table.

Signature
C#
C#
public SetShowValueAs(PivotTableField.ShowValueAsType showValueAs, SourceField baseField, Int32 baseItemIndex)
Signature
vb.net
vb.net
public Function SetShowValueAs(ByVal showValueAs As PivotTableField.ShowValueAsType, ByVal baseField As SourceField, ByVal baseItemIndex As Int32)
Parameters
Param
showValueAs
showValueAs

The type of ShowValueAs described by ShowValueAsType.

Param
baseField
baseField

The base field for comparisons.

Param
baseItemIndex
baseItemIndex

The index of the base item for comparisons

Example
Code Block
csharp
csharp
titleC#
ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Open(@"C:\MySpreadsheet.xlsx");
          Worksheet ws = wb.Worksheets[0];
          PivotTable pt = ws.PivotTables[0];
          DataField df = pt.DataFields[0];
          df.SetShowValueAs(PivotTableField.ShowValueAsType.Difference, pt.SourceFields[0], 0);
Code Block
vb.net
vb.net
titlevb.net
Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Open("C:\MySpreadsheet.xlsx")
          Dim ws As Worksheet = wb.Worksheets(0)
          Dim pt As PivotTable = ws.PivotTables(0);
          Dim df As DataField = pt.DataFields(0)
          df.SetShowValueAs(PivotTableField.ShowValueAsType.Difference, pt.SourceFields(0), 0);