Data Sorting in Excel

This sample demonstrates how to sort data in spreadsheet using XlsIO.

DEMO

SOURCE

Click the "View Input Template" button to view the input Excel document and click the "Sort Values" button to view the output Excel document. Please note that the Microsoft Excel viewer or Microsoft Excel is required to view the Excel document.

Sort On Values

Choose the column to sort:

First Column:

Add Level

Second Column:

Add Level

Third Column:

Order By

Ascending

Descending

Essential XlsIO can sort a range of cells dynamically, at runtime without any dependency on MS Excel. It sorts the data based on values and colors.

Features:

Supports to sort the large data
Sorts based on the selected algorithm
Sorts the data based on the cell and font color