Sorting and AutoFilter

The ASP.NET Core Spreadsheet control allows you to sort data against column values. Use the commands located on the Data tab or a table header’s dropdown menu to sort column data or change column sort order (from ascending to descending, and vice versa).

The auto filter allows end-users to filter data by columns and to display only rows that meet specific conditions. Use the commands located on the Data tab or a table header’s dropdown menu to activate or reapply the filter, or completely remove all filters in a worksheet.

See more Hide details

Prev Demo Next Demo

Was this demo helpful?

Thank you!

Feel free to share demo-related thoughts here.
If you have technical questions, please create a support ticket in the DevExpress Support Center.

Send Feedback

Thank you!
We appreciate your feedback.

Backend API

@inject IWebHostEnvironment env @{ var documentPath = System.IO.Path.Combine( env.ContentRootPath, DirectoryManagmentUtils.GetDocumentSampleFolderPath(Context), "AutoFilter.xlsx"); } @(Html.DevExpress() .Spreadsheet("spreadsheet") .Height("500px") .Width("100%") .Ribbon(ribbon => ribbon.ActiveTabIndex(3)) .ConfirmOnLosingChanges(confirm => confirm.Enabled(false)) .DocumentRequestHandlerUrl(Url.Action("DxDocumentRequest")) .Open(documentPath) )

using System; using System.IO; using System.Linq; using System.Text; using DevExpress.AspNetCore.Spreadsheet; using DevExpress.Spreadsheet; using DevExpress.XtraSpreadsheet.Export; using Microsoft.AspNetCore.Hosting; using Microsoft.AspNetCore.Mvc; namespace AspNetCoreDemos.Spreadsheet { [Route("[action]")] public class SpreadsheetController : Controller { public ActionResult Tables() { return View(); } } }