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

Versions Compared

Old Version 12

changes.mady.by.user Alison Bird [softartisans]

Saved on

compared with

New Version Current

changes.mady.by.user Alison Bird [softartisans]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Introducedin
8.4

...

8.4
Description

Excerpt

Sets or returns the ordering of the PivotTableField using an OrderingType. This only has an affect on row labels and column labels.

Signature
C#
C#
 public SortOptions.OrderingType Ordering{ get; set; }
{signature}{signature:
}
Signature
vb.net
vb.net
Public Property Ordering() As SortOptions.OrderingType
{signature}

{example}{code:csharp|title=C#}
Example
Code Block
csharp
csharp
titleC#


          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Open("template.xlsx");
          PivotTable pt = wb[0].PivotTables[0];
          pt.ColumnLabels[0].SortOptions.Ordering = SortOptions.OrderingType.Ascending;
{code} {code:vbnet|title=
 Code Block
vbnet
vbnet
titlevb.net
}


          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Open("template.xlsx")
          Dim pt As PivotTable = wb(0).PivotTables(0)
          pt.ColumnLabels(0).SortOptions.Ordering = SortOptions.OrderingType.Ascending;
        
{code}

{example}

{remarks}
ExcelWriter does not have the ability to perform the actual sorting action. This is handled by Excel when the output is opened in Excel and the PivotTable is refreshed. This property determines how Excel sorts the values for a particular PivotTable field.
{remarks}
 Remarks
ExcelWriter does not have the ability to perform the actual sorting action. This is handled by Excel when the output is opened in Excel and the PivotTable is refreshed. This property determines how Excel sorts the values for a particular PivotTable field.