Page History

...

{introducedin: 8.4

...

{signature}

{example}{code:csharp|title=C#}

          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Open("template.xlsx");
          SortOptions options = wb[0].PivotTables[0].ColumnLabels[0].SortOptions;
        

{code}
{code:vbnet|title=vb.net

}

          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Open("template.xlsx")
          Dim options As SortOptions = wb(0).PivotTables(0).ColumnLabels(0).SortOptions;
        

}{description}
{excerpt}The {{SortOptions}} class contains all of the sorting options for a {{[EW8:PivotTableField]}}.{excerpt}
{signature:C#}
 public sealed class SortOptions

{signature}{signature:vb.net

}
Public NotInheritable Class SortOptions

...

Name

...

Description

...

Ordering

...

OrderingType

...

{code}

{example}
{properties}
|| Name || Description ||
| [Ordering|SortOptions.Ordering] | {excerpt-include:SortOptions.Ordering|nopanel=true} |
| [OrderingType|SortOptions.OrderingType] | {excerpt-include:SortOptions.OrderingType|nopanel=true} |