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

Versions Compared

Old Version 6

changes.mady.by.user Sam Haddad [softartisans]

Saved on

compared with

New Version 7

changes.mady.by.user Sam Haddad [softartisans]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

Wiki Markup
{introducedin: 8.6

...

Description

Excerpt

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

{signature}
{example}{code: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=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;
Signature
C#C#
}
{description}
{excerpt}Sets or returns whether the PivotTable will display in classic layout mode{excerpt}
{signature:C#}
 public boolean ClassicLayout{ get; set; }
Signature
{signature}{signature:vb.net
vb.net
}
Public Property ClassicLayout() As Boolean
Example
Code Block
csharpcsharp
titleC#
Code Block
vbnetvbnettitle
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.
{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}