Wiki Markup |
---|
{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} | |
Page History
Overview
Content Tools