changes.mady.by.user Whitney Sternberg [softartisans]
Saved on Sep 17, 2012
changes.mady.by.user Anonymous
Saved on Jan 08, 2013
The SortOptions class contains all of the sorting options for a PivotTableField.
SortOptions
PivotTableField
public sealed class SortOptions
...
ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.CreateOpen("template.xlsx"); SortOptions itemsoptions = wb[0].PivotTables[0].ColumnLabels[0].SortOptions;
Dim xla As New ExcelApplication() Dim wb As Workbook = xla.CreateOpen("template.xlsx") Dim paloptions As SortOptions = wb[(0]).PivotTables[(0]).ColumnLabels[(0]).SortOptions;
Name
Description
Ordering
OrderingType