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

This sample demonstrates how to use Autofilters in spreadsheets using XlsIO.

DEMO

SOURCE

Click the "Input Template" button to view the input Excel document and click the "Create Document" button to view the created Excel document. Please note that the Microsoft Excel viewer or Microsoft Excel is required to view the Excel document.

Select the Filter Type

Action Type Filter In Place Filter Copy

Unique Records

Filter Type Font Color Cell Color

Color

IconSet Type

Icon ID

XlsIO can filter a range of cells dynamically without any dependency of Microsoft Excel.

Features:

Custom Filter
Text Filter
DateTime Filter
Dynamic Filter
Color Filter
Icon Filter
Advanced Filter