• Material
  • Fabric
  • Bootstrap
  • High Contrast
Preferences
Theme Selection
Mode Selection
Touch
Mouse
Essential JS 2
HOME
All Controls

Button

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

Click the button to view an Excel spreadsheet generated by Essential XlsIO. Please note that Microsoft Excel Viewer or Microsoft Excel is required to view the resultant document.


Sort On Values

Choose the column to sort:

First Column:                   

Add Level

Second Column:              

Add Level

Third Column:                 

Order By

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