OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 8

changes.mady.by.user Anonymous

Saved on

compared with

New Version Current

changes.mady.by.user Anonymous

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Introducedin
8.4

...

8.4
Description

Excerpt

The SortOptions class contains all of the sorting options for a PivotTableField.

Signature
C#
C#
 public sealed class SortOptions
{signature}{signature:
}
Signature
vb.net
vb.net
Public NotInheritable Class SortOptions
{signature}

{example}{code:csharp|title=C#}
Example
Code Block
csharp
csharp
titleC#


          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Open("template.xlsx");
          SortOptions options = wb[0].PivotTables[0].ColumnLabels[0].SortOptions;
{code} {code:vbnet|title=
 Code Block
vbnet
vbnet
titlevb.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} |
 Properties
 Name 
 Description 
 Ordering 
 Excerpt Include
SortOptions.Ordering
SortOptions.Ordering
nopaneltrue
 OrderingType 
 Excerpt Include
SortOptions.OrderingType
SortOptions.OrderingType
nopaneltrue