We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Overview

The Spreadsheet control for ASP.NET provides a Microsoft Excel-like control for the web. It supports all the features of Microsoft Excel, including editing, formulas, importing, exporting, and more.

Spreadsheet is Microsoft Excel-like control


Editing

The spreadsheet control for JavaScript supports editing directly inside cells or in the formula bar.

Cell editing in Spreadsheet


Sorting and Filtering

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

Spreadsheet with sorting and filtering


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 wrapping of text 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.

Spreadsheet with multi-range selection


Drag Fill

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

Auto fill the cells in Spreadsheet using Drag-fill


Importing and Exporting

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.


Undo and Redo

The undo feature allows the user to revert the most recent actions, and redo cancels the recent undo actions. There is no fixed limit to the number of undo/redo operations.


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.

Data validation in Spreadsheet


Conditional Formatting

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

Conditional formatting in Spreadsheet


Data Binding with Batch Save

Now you can use the spreadsheet as a data-bound widget. That is, you can bind a data source to spreadsheet’s sheet or its range cells and send back the changes 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 has support to set values, formulas, comments, hyperlinks, cell formats, and number formats via this API.

Cell binding in Spreadsheet


Pivot Table

Pivot table support has been added to summarize and analyze large amounts of data in spreadsheet.

Pivot table in 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.

Mobile view of Spreadsheet Tab view of spreadsheet


Touch Optimized

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

Touch support in Spreadsheet


PDF Exporting

Spreadsheet content can be exported to PDF files.


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.

Read Only for cells in Spreadsheet


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.

Context Menu customization in Spreadsheet


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.

 Excel-Like Pivot Table support in Spreadsheet


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.

Frozen rows and columns in Spreadsheet


70+ ASP.NET UI CONTROLS

Transform your applications today by downloading our free evaluation versionDownload Free Trial

Scroll up icon

Warning Icon 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.Close Icon