ASP.NET MVC Spreadsheet - Syncfusion ASP.NET MVC UI Controls

The ASP.NET MVC 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

Performance

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.

Formulas

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.

Data Editing

• Data editing in ASP.NET MVC Spreadsheet comes with the ability to add, edit, and remove formulas/values in a cell.
• Validate the edited values based on the data validation rules defined for a cell or range of cells.
• There's built-in support for hyperlinks and bookmarks.

Formatting

Formatting in ASP.NET MVC Spreadsheet options make your data easier to view and understand. 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.

Conditional formatting

In ASP.NET MVC 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

• Data in columns or rows on a worksheet can be plotted as a chart. Spreadsheet supports various chart types
  • Line chart
  • Column chart
  • Bar chart
  • Pie or Doughnut chart
  • Area chart
• Sparklines used to show trends in series of values. It is a small chart in the cell of worksheet.
• Pivot table support for summarizing and analyzing large amounts of data in Spreadsheet.

Touch optimized

The ASP.NET MVC 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.

Related links

Learn More about ASP.NET MVC Spreadsheet

Download Free Trial

Pricing

Documentation

View Demos

Community Forums

Knowledge base

Suggest a feature

About Syncfusion ASP.NET MVC UI Controls

The Syncfusion ASP.NET MVC UI controls library is the only suite that you will ever need to build an application since it contains over 85 high-performance, lightweight, modular, and responsive UI controls in a single package. In addition to Spreadsheet, we provide popular ASP.NET MVC Controls such as ASP.NET MVC DataGrid, ASP.NET MVC Charts, ASP.NET MVC Scheduler, ASP.NET MVC Diagram, and ASP.NET MVC Word Processor.

About Syncfusion

Founded in 2001 and headquartered in Research Triangle Park, N.C., Syncfusion has more than 29,000 companies and more than 1 million users, including large financial institutions, Fortune 500 companies, and global IT consultancies.

Today, we provide 1800+ controls and frameworks for web (ASP.NET Core, ASP.NET MVC, ASP.NET WebForms, JavaScript, Angular, React, Blazor, Vue, and Flutter), mobile (Xamarin, UWP, JavaScript, and Flutter), and desktop development (Windows Forms, WPF, UWP, Flutter, WinUI, and .NET MAUI). We provide ready-to-deploy enterprise software for dashboards, reports, data integration, and big data processing. Many customers have saved millions in licensing fees by deploying our software.

sales@syncfusion.com | Toll Free: 1-888-9 DOTNET