Page History

{introducedin: 8.4}{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
{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;
        {code}

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