• Fluent
  • Fluent Dark
  • Bootstrap v5
  • Bootstrap v5 Dark
  • Tailwind CSS
  • Tailwind CSS Dark
  • Material
  • Bootstrap v4
  • High Contrast
Preferences
Mode Selection
Touch
Mouse
Theme Selection
Localization
*Translated by Google Translator.
Currency
Essential Studio
HOME
All Controls

Example of Data Sorting in ASP.NET Core Excel (XlsIO) Library

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

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