The SortOptions class contains all of the sorting options for a PivotTableField.
SortOptions
PivotTableField
public sealed class SortOptions
Public NotInheritable Class SortOptions
ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Open("template.xlsx"); SortOptions options = wb[0].PivotTables[0].ColumnLabels[0].SortOptions;
Dim xla As New ExcelApplication() Dim wb As Workbook = xla.Open("template.xlsx") Dim options As SortOptions = wb(0).PivotTables(0).ColumnLabels(0).SortOptions;
Name
Description
Ordering
OrderingType