.
Introduced in build 8.4
Description
The SortOptions class contains all of the sorting options for a PivotTableField.
C#
public sealed class SortOptions |
vb.net
Public NotInheritable Class SortOptions |
Examples
C#
ExcelApplication xla = new ExcelApplication();Workbook wb = xla.Open("template.xlsx");SortOptions options = wb[0].PivotTables[0].ColumnLabels[0].SortOptions; |
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; |
Properties
Name |
Description |
|---|---|
Sets or returns the ordering of the PivotTableField using an OrderingType. This only has an affect on row labels and column labels. |
|
|
The |