The ASP.NET MVC Spreadsheet or Excel viewer, is a feature-rich control for organizing and analyzing data in tabular format with some cool features like Microsoft Excel. It provides all the common Excel features, including data binding, selection, editing, formatting, resizing, sorting, and importing and exporting Excel documents.
Bind data seamlessly with various local and remote data sources such as JSON, RESTful services, OData services, and WCF services. The control uses the data manager to handle data and supports customizing data requests and processing.
The ASP.NET MVC Spreadsheet (Excel like grid) is designed and optimized for high performance in every aspect.
Instant loading allows users to load large amounts of data into a worksheet and view it on demand with the help of row and column virtualization.
The ASP.NET MVC Spreadsheet control provides a smooth scrolling experience even with many cells in a view.
In the ASP.NET MVC Spreadsheet, data editing allows you to add, edit, and remove formulas or values in a cell. You can edit the contents of a cell directly in the cell or by typing in the formula bar.
The ASP.NET MVC Spreadsheet widget provides interactive support to highlight cells, rows, columns, and sheets that you select. Selection can be done through mouse, touch, or keyboard interaction.
The ASP.NET MVC Spreadsheet library provides a wide range of formulas with cross-sheet references support.
The ASP.NET MVC Spreadsheet provides a built-in calculation engine, which is suitable for most of your calculations. Spreadsheet also provides an option to create and use your own custom formulas.
Values are automatically recalculated when a dependent cell is edited.
Number formatting provides a type for your data in Spreadsheet. It helps to display your data as currency, percentages, short dates, long dates, time, fractions, and scientific numbers, similar to Excel.
Using cell formatting, users can highlight a particular cell or range of cells from a whole workbook. The control supports various formatting options: font size, font family, font color, fill color, indent, and horizontal and vertical alignments of text.
The ASP.NET MVC Spreadsheet control can load Excel documents initially or open them like an Excel application with data accuracy, styles, and formats. Microsoft Excel (.xlsx), Microsoft Excel 97-2003 (.xls), and comma-delimited values (.csv) file formats can be opened in Spreadsheet.
Easily save the Spreadsheet control with data accuracy, styles, and formats as an Excel file. It supports various file formats such as Microsoft Excel (.xlsx), Microsoft Excel 97-2003 (.xls), and comma-delimited values (.csv).
You can reorganize your data faster by sorting the range of cells in either ascending or descending order. Custom sort option allows you to sort multiple columns.
The MVC Spreadsheet provides an interactive ribbon that organizes spreadsheet’s features into a series of tabs. You can collapse the ribbon to make more rows visible on the viewport.
Use the clipboard operations cut, copy, and paste, just like in Microsoft Excel. You can paste the values or formulas with or without formatting in a new selected range.
The context menu improves user interaction with Spreadsheet using a pop-up menu. It appears when a cell, row header, column header, or sheet tab is right-clicked. In addition to built-in default menu items, it allows you to add custom context menu items.
The resize and autofit options help you adjust the row height and column width.
The ASP.NET MVC Excel Spreadsheet ensures that every cell is accessible using the keyboard. Major features like selection, clipboard, and editing can be performed using keyboard commands alone; no mouse interaction is required. This helps in creating highly accessible applications using this control.
The ASP.NET MVC Excel like Grid view has complete WAI-ARIA accessibility support. The Spreadsheet UI includes high-contrast visual elements, helping visually impaired people have the best viewing experience. Also, valid UI descriptions are easily accessible through assistive technologies such as screen readers.
Five built-in, SASS-based themes are available: Material, Bootstrap, Bootstrap 4, Fabric, and high contrast. Simplify theme customization either by overriding the existing SASS styling or creating custom themes using the Theme Studio application.
The ASP.NET MVC Spreadsheet enables users from different locales to use it by formatting the dates, currency, and numbering to suit local preferences. It uses the internalization (i18n) library to handle number formatting.
Right-to-left rendering allows you to display the text and layout of the Spreadsheet from right to left. This improves the user experience and accessibility for RTL languages.
Users can localize all the strings used in the user interface of the ASP.NET MVC Spreadsheet control. The control uses the localization (l10n) library to localize UI strings.
The ASP.NET MVC Spreadsheet works well with all modern web browsers: Chrome, Firefox, Edge, Safari, and IE11. It supports IE11 with the help of polyfills.
Developers can customize their UI and control its behaviors according to the end user’s requirement using the control’s rich set of client-side APIs.
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.