Page History

...

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 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;

Remarks

ClassicLayout is false by default.

This property corresponds to the Classic PivotTable layout setting under PivotTable Options on the display tab. This enables dragging of fields in the grid.

Space Shortcuts

Page tree

Versions Compared

Old Version 3

New Version 4

Key