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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback


Overview

Sort and filter are the best data management features that Excel provides as built-in. Syncfusion XlsIO supports these great features completely.


Sort Excel Data

Excel sorting allows to sort worksheet data in number of ways. Therefore, Syncfusion XlsIO conveniently sort numbers, texts, and colors.

Sort by Value

Column with values of number, text or date can be sorted, either in ascending or descending order.

Sort by Color

Cell values with different fore colors can sort, which helps in visualizing values in priority. Also sorts cells with its cell color.

Multiple Level Sort

In addition, sorting can be customized by choosing multiple columns in required order.


Filter Excel Data

Auto filter is a quick and easy way to find, show, or hide values in one or more columns. Applying filter will display the rows that meet the filter criteria. Syncfusion XlsIO (Excel library) supports filtering data with these filters.

Color Filter

Syncfusion XlsIO supports Excel color filter to quickly filter columns based on fore color or cell color that is applied either manually or by conditional formatting.

Icon Filter

Icon sets that create visual effects in Excel data. Also, applying icon sets for numeric data adds icons to each cell based on its value. Syncfusion XlsIO supports filtering data based on cell icon.

Excel Combination Filter

Syncfusion XlsIO supports Excel combination filter to filter data when a column contains different data types like text, time value, date time value, and more. This also filters data based on multiple criteria.

Excel Custom Filter

Custom filter in Excel provides an option to filter data with various conditions based on cell type. Syncfusion XlsIO supports all the filter conditions of Excel.

Excel Dynamic Filter

Dynamic filter is a relative date filter that filters data based on cell date. Therefore, Syncfusion XlsIO supports with the dynamic filter types, day, week, month and year.

Advanced Filter

Syncfusion XlsIO supports Excel advanced filter to filter data with complex criteria like filter data in the same location or filter and copy the filtered data to a new location. This helps identify duplicate records and copy the extracted data to another location within the worksheet.



PRICING

Cody Icon

File Formats

$ 995

One developer per license

Developer Platform

Essential Studio

$ 1,995

One developer per license

best-img

Unlimited Global License

Cover everyone in your organization for one low annual fee

CONTACT US
DEVELOPER PLATFORM
1,000+ web, desktop, and mobile controls
Predictive Analytics
File Formats (Word, Excel, PowerPoint, and PDF)
DATA PLATFORM
Dashboard Platform
Big Data Platform
Report Platform
Data Integration Platform
SUPPORT
Dedicated Account Representative
Quarterly product releases
Support within 24 hours on all business days
LICENSING
Licensing Management Portal
Commercial Use
Max Developer Count
1 per license
1 per license
Unlimited
Coverage Period
1 year
1 year
1 year

RESOURCES

CASE STUDY

Syncfusion’s file format components helped me create the reports I needed, fast. – J. Pereira, Software Developer.

The libraries have been built from scratch and refined for more than a decade to provide blazing-fast performance, comprehensive API, and compatibility across the latest and older versions of these files.

CONTINUE READING View all Customer Stories

VIDEOS

Syncfusion File Format Libraries - Manipulate Excel, Word, PowerPoint, and PDF files

Read and write Excel, Word, PDF, and PowerPoint files. Also includes integrated visualization capabilities. Advanced features include support for pivot tables, pivot charts, mail-merge, and extensive formatting.

E-BOOK

Succinctly Series: Statistics Using Excel Succinctly

Succinctly Series: Statistics Using Excel Succinctly


- by Charles Zaiontz
CONTINUE READING View all E-books

A well known industry partner

Working with the industry’s best and brightest minds to streamline reporting

Syncfusion Customers
  • "Syncfusion has all of the required controls, reporting and dashboarding tools across multiple platforms that allow us to leverage our existing skills with a simple and value-for-money licensing model."
    Jono Walker, Walkerscott
  • "An excellent toolset and a great support team. I’ve been using Syncfusion’s products for a couple of years, and they save me a lot of time on development."
    Oswaldo Diaz, Product Manager, Hipermetrics.com

Awards

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.

Syncfusion Awards
Scroll up icon

Warning Icon 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.Close Icon