We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Sort and filter are the best data management features that Excel provides built-in. Excel Library supports these great features completely.
Sorting allows you to sort worksheet data like numbers, text, and colors in a number of ways.
Columns with number, text, or date values can be sorted in either ascending or descending order.
Cell values with different foreground or cell colors can be sorted, which helps in visualizing values by priority.
Sorting can be customized by choosing multiple columns in a required order.
Auto filtering is a quick and easy way to find, show, or hide values in one or more columns. Applying this filter will display the rows that meet the filter criteria.
Excel Library supports the Excel color filter to filter columns quickly based on the foreground color or cell color that is applied either manually or by conditional formatting.
Icon sets create visual effects in Excel data. Applying icon sets for numeric data adds icons to each cell based on its value. Excel Library supports filtering data based on cell icons.
Excel Library supports the Excel combination filter to filter data when a column contains different data types like text, time values, and date-time values. It also filters data based on multiple criteria.
The custom filter in Excel provides an option to filter data with various conditions based on cell type. Excel Library supports all the filter conditions of Excel.
The dynamic filter is a relative date filter that filters data based on cell date. Excel Library supports the dynamic filter types day, week, month, and year.
Excel Library supports the Excel advanced filter to either filter data with complex criteria (like filtering data in the same location) or filter and then copy the filtered data to a new location. This helps identify duplicate records and copy the extracted data to another location within the worksheet.
Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion is proud to hold the following industry awards.
You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.
