Sort and filter are the best data management features that Excel provides as built-in. Syncfusion XlsIO supports these great features completely.
Excel sorting allows to sort worksheet data in number of ways. Therefore, Syncfusion XlsIO conveniently sort numbers, texts, and colors.
Column with values of number, text or date can be sorted, either in ascending or descending order.
Cell values with different fore colors can sort, which helps in visualizing values in priority. Also sorts cells with its cell color.
In addition, sorting can be customized by choosing multiple columns in required order.
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.
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 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.
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.
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.
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.
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.
/developer 1st year
Cover everyone in your organization for one low annual feeCONTACT US
/developer 1st year
Syncfusion’s file format components helped me create the reports I needed, fast. – J. Pereira, Software Developer.
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.
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.