Message-ID: <1280615248.8617.1711652304028.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8616_666924363.1711652304028" ------=_Part_8616_666924363.1711652304028 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Sets or returns whether the values labels field should be placed as a Ro= w Label or Column Label
=20public boolean CalculatedFieldsOnRow{ get; set; }=20
Public Property CalculatedFieldsOnRow() As Boolean=20
ExcelApplication xla =3D new ExcelApplication(); Workbook wb =3D xla.Open(@"C:\MySpreadsheet.xlsx"); Worksheet ws =3D wb.Worksheets[0]; ws.PivotTables[0].PivotTableSettings.ValuesLabelOnRow =3D true;=20
Dim xla As New ExcelApplication() Dim wb As Workbook =3D xla.Open("C:\MySpreadsheet.xlsx"= ) Dim ws As Worksheet =3D wb.Worksheets(0) ws.PivotTables(0).PivotTableSettings.ValuesLabelOnRow =3D true;=20
ValuesLabelOnRow is false
by default.
When creating a pivot table, set this option before adding any fields to=
ensure the values label field is created where it is intended.
If th=
is option is changed on a pivot table that already has a values label field=
, that field will be moved to the new position.