We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to sort pivot fields in Excel using XlsIO?

Platform: WinForms |
Control: XlsIO |
Published Date: January 24, 2018 |
Last Revised Date: January 24, 2018

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.

Download Complete Sample

The following C#/VB complete code snippet shows how to sort pivot fields in Excel using XlsIO.

C#

 

VB

 

 

 

ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon