Page History

...

Signature

	vb.net
	vb.net

Public Property Ordering() As SortOptions.OrderingType

Example

Code Block

	csharp
	csharp
title	C#



          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Open("template.xlsx");
          wb[0].PivotTables[0].ColumnLabels[0].SortOptions.Ordering = SortOptions.OrderingType.Ascending;

Code Block

	vbnet
	vbnet
title	vb.net



          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Open("template.xlsx")
          wb[0].PivotTables[0].ColumnLabels[0].SortOptions.Ordering = SortOptions.OrderingType.Ascending;

Remarks
ExcelWriter does not have the ability to perform the actual sorting action. This is handled by Excel when the output is opened in Excel and the pivot table is refreshed. This property determines how Excel sorts the values for a particular field.

Space Shortcuts

Page tree

Versions Compared

Old Version 4

New Version 5

Key