The ASP.NET Core Spreadsheet is a Microsoft Excel-like control for the web that allows you to create, view, edit and format Microsoft Excel files. It ships with a built-in calculation engine with support for more than 200 of the most widely used formulas. Its functionalities include editing, data binding, filtering, formulas, charts, formatting, data validation, pivot tables, printing, importing and exporting.
Features and benefits
Spreadsheet is designed and optimized for high performance. A high volume of data can be loaded without performance degradation by using row virtualization.
Sort and filter
Analyze data with automatic filtering and sorting. The Spreadsheet control provides support for filtering specific data from the spreadsheet and sorting columns by ascending or descending order.
A wide range of formulas is available with cross-sheet references, named ranges support.The built-in calculation engine is preloaded with more than 200 Excel-compatible functions covering a broad range of business scenarios.
Number formatting changes the appearance of numbers in a cell by adding percent signs, commas, currency symbols, decimals, and more to signify different meanings. Text formatting allows users to change the font, font size, color, weight, style, alignment, and wrapping of text in a cell.
In ASP.NET Core Spreadsheet, Conditional formatting helps you visually explore and analyze data, detect critical issues, and identify patterns and trends. Format the appearance of cells based on their value or the values of any other cells.
Charts and Pivot table
The ASP.NET Core Spreadsheet control is touch-optimized for all user interactions like swipe for scrolling and taps for selection, sorting, filtering and more.
Import and Export
Existing Excel worksheets can be imported into the Spreadsheet control and edited by users. This control supports exporting spreadsheets as XLS, XLSX, and comma-delimited value files.
Founded in 2001 and headquartered in Research Triangle Park, N.C., Syncfusion has more than 20,000 customers and more than 1 million users, including large financial institutions, Fortune 500 companies, and global IT consultancies.