Page History

...

Introducedin

	8.6

...


	8.6

Description

Excerpt
Sets or returns whether the PivotTable will display in classic layout mode

Signature

	C#
	C#

 public boolean ClassicLayout{ get; set; }
{signature}{signature:

}

Signature

	vb.net


	vb.net

Public Property ClassicLayout() As Boolean
{signature}
{example}{code:csharp|title=C#}

Example

Code Block

	csharp
	csharp
title	C#



          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Open(@"C:\MySpreadsheet.xlsx");
          Worksheet ws = wb.Worksheets[0];
          ws.PivotTables[0].PivotTableSettings.ClassicLayout = true;

{code} {code:vbnet|title=

Code Block

	vbnet
	vbnet
title	vb.net

}



          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Open("C:\MySpreadsheet.xlsx")
          Dim ws As Worksheet = wb.Worksheets(0)
          ws.PivotTables(0).PivotTableSettings.ClassicLayout = true;

{code} {example} {remarks} This property corresponds to the Classic PivotTable layout setting under PivotTable Options on the display tab. This enables the ability to drag and drop fields in the PivotTable grid. The default value of ClassicLayout is {{false}} for PivotTables generated by ExcelWriter. {remarks}

Remarks

This property corresponds to the Classic PivotTable layout setting under PivotTable Options on the display tab. This enables the ability to drag and drop fields in the PivotTable grid.

The default value of ClassicLayout is false for PivotTables generated by ExcelWriter.

Space Shortcuts

Page tree

Versions Compared

Old Version 11

New Version Current

Key