This article explains how to sort pivot fields in Excel using XlsIO.
What is a Pivot Table?
A pivot table is a program tool that allows you to reorganize and summarize selected columns and rows of data in a spreadsheet or database table to obtain a desired report.
Pivot table is used to build a list of unique values. Because pivot tables summarize data, and can be used to find unique values in a field. This is a good way to quickly see all the values that appear in a field.
Sample code to sort pivot fields in Excel using XlsIO
NOTE: This is applicable to apply custom sorting in pivot table.
The following C#/VB complete code snippet shows how to sort pivot fields in Excel using XlsIO.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|