Message-ID: <576699882.8375.1711643766715.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8374_539875951.1711643766715" ------=_Part_8374_539875951.1711643766715 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Sets or returns whether the PivotTable will display in classic layout mo= de
=20public boolean ClassicLayout{ get; set; }=20
Public Property ClassicLayout() 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.ClassicLayout =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.ClassicLayout =3D true;=20
This property corresponds to the Classic PivotTable layout setting under= PivotTable Options on the display tab. This enables the ability to drag an= d drop fields in the PivotTable grid.
=20The default value of ClassicLayout is false
for PivotTables=
generated by ExcelWriter.