Your search did not match any results.

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.

Prev Demo
Next Demo
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(); } } }