Your account has not been activated. Click here to get a new activation Email.
Unfortunately, activation email could not send to your email. Please try again.

Spreadsheet

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.


Editing

The spreadsheet control for ASP.NET Core supports editing directly inside cells or in the formula bar.


Sorting and Filtering

The spreadsheet control provides support for filtering specific data from the spreadsheet and sorting columns by ascending or descending order.


Formatting

The spreadsheet control provides a variety of formatting options for text and numbers to improve the appearance and effectiveness of any spreadsheet.


Number Formatting

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

Text formatting allows users to change the font, font size, color, weight, style, alignment, and text wrapping in a cell.


Selection

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

Drag fill allows users to automatically fill cells with data that follows or completes a pattern based on data in other cells.


Importing and Exporting

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.

Importing

Exporting


Undo and Redo

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.

Before undo

After undo

After redo


Printing

Users can print the entire spreadsheet or only selected data.


Data Validation

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

Conditional formatting applies different formatting styles to select cells based on conditions provided by users.


Data Binding with Batch Save

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.


Cell Binding

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

Pivot table support allows users to summarize and analyze large amounts of data in a spreadsheet.


Responsive Rendering

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.


Touch Optimized

All spreadsheet control features are optimized for touch screens. This includes swipes for scrolling and taps for selecting, filtering, and sorting.


Data Virtualization

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.


Read-Only Support

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.


Context Menu Customization

The spreadsheet context menu can be customized. Context menu items can be added, deleted, disabled, and enabled, and their data sources can be updated.


Initial Rendering Performance

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.


Excel-Like Pivot Table Support

The look and feel of pivot tables in the spreadsheet control have been modified to be similar to Excel pivot tables.


Freeze panes

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.


You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.