The spreadsheet control for ASP.NET Core provides a Microsoft Excel-like spreadsheet component for the web. It provides an editing experience that is very similar to that of Excel, and it is able to import and export Excel workbook files.
The spreadsheet control for ASP.NET Core supports editing directly inside cells or in the formula bar.
The spreadsheet control provides support for filtering specific data from the spreadsheet and sorting columns by ascending or descending order.
The spreadsheet control provides a variety of formatting options for text and numbers to improve the appearance and effectiveness of any spreadsheet.
Number formatting changes the appearance of numbers in a cell by using 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 text wrapping in a cell.
The selection feature allows users to select a single cell, a range of cells, entire rows, or entire columns in a spreadsheet. The selected data can then be manipulated.
Drag fill allows users to automatically fill cells with data that follows or completes a pattern based on data in other cells.
Existing Excel worksheets can be imported into the spreadsheet control and edited by users. This control supports exporting spreadsheet as .xls, .xlsx, comma-delimited value, and .pdf files.
The undo feature allows users to revert the most recent actions, and redo cancels the recent undo actions. There is no fixed limit to the number of undo and redo operations.
Users can print the entire spreadsheet or only selected data.
Data validation restricts what users are allowed to enter as data. If entered data does not meet the specified criteria, an error message is displayed.
Conditional formatting applies different formatting styles to select cells based on conditions provided by users.
The spreadsheet can be used as a data-bound widget. That is, you can bind a data source to a whole spreadsheet or a specific range of cells and send changes back to a remote server, or even to an in-memory object.
You can predefine or override each cell in a spreadsheet with a simple JSON object that supports setting values, formulas, comments, hyperlinks, cell formats, and a number formats via this API.
Pivot table support allows users to summarize and analyze large amounts of data in a spreadsheet.
The spreadsheet control will adaptively render an optimal user interface for phone, tablet, or desktop form factors, helping applications scale elegantly without any additional effort.
All spreadsheet control features are optimized for touch screens. This includes swipes for scrolling and taps for selecting, filtering, and sorting.
The spreadsheet control supports on-demand data loading when bound to remote and local data sources. This feature greatly improves initial loading time by requesting only the visible data from the data source.
The read-only feature allows spreadsheets to be read and copied, and comments to be displayed and searched, but the spreadsheet contents cannot be modified.
The spreadsheet context menu can be customized. Context menu items can be added, deleted, disabled, and enabled, and their data sources can be updated.
Spreadsheet performance has been improved during initial rendering. The loading time has been reduced, which is useful for rendering multiple spreadsheets in a single page without lagging.
The look and feel of pivot tables in the spreadsheet control have been modified to be similar to Excel pivot tables.
Freeze panes is a feature that allows a row or column to lock in place, making it always visible when scrolling vertically or horizontally. Spreadsheet allows users to freeze columns to the left or right or freeze rows to the top or bottom of the worksheet.