Syncfusion jQuery no longer in active development. Switch to our pure JavaScript based next generation Essential JS 2 .

Try Essential JS 2

Built-in features like cell and conditional formatting, formulas, pivot tables, charts, sorting, filtering, and more.
Flexible data binding for sheets and ranges, plus support for exporting to formats like XLS, XLSX, CSV, and PDF.
Large volumes of data can be loaded using virtualization.

Trusted by the world’s leading companies

ASP.NET spreadsheet

Overview

The ASP.NET Web Forms Spreadsheet control 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.

Excel-like interactive Ribbon UI

The Spreadsheet ribbon provides a familiar, Excel-like user interface to help end users work with Excel files.
The ribbon helps you manipulate Excel workbooks through UI interactions.
You can customize the ribbon easily to manipulate Excel workbooks.

Spreadsheet is Microsoft Excel-like control

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.

Import and export documentation

Performance

excel like edit in spreadsheet

Instant loading

Load and manipulate Excel workbooks with a large amount of data using row virtualization and any number of worksheets in less time using the sheet-on-demand option.

excel like edit in spreadsheet

Smooth scrolling

The ASP.NET Web Forms Spreadsheet control provides a smooth scrolling experience even with many cells in a view.

Data editing

excel like edit in spreadsheet

Editing

In the Spreadsheet control, data editing comes with the ability to add, edit, and remove formulas or values in a cell. Users can also select the range reference directly using the mouse or keyboard while entering formulas, like in Excel.

Data editing documentation

data validation for spreadsheet

Data validation

Validate the edited values based on the data validation rules defined for a cell or range of cells. Data validations can be applied with operators and drop-down lists.

Data validation documentation

undo and redo operations for spreadsheet control

Undo and redo

Undo and redo changes made in an Excel workbook. You can customize the limit of undo and redo operations you can perform.

Undo and redo documentation

clipboard operations spreadsheet control

Clipboard operations

Clipboard operations with Excel-like paste options enable users to paste values or formulas with or without formatting in a spreadsheet.

Clipboard operations documentation

fill series like excel

Drag-fill

The drag-fill feature allows users to easily fill or copy a series or pattern of values and formats into neighboring cells in any direction.

Drag fill documentation

hyperlinks and bookmarks for spreadsheet

Hyperlinks and bookmarks

There’s built-in support for hyperlinks and bookmarks. You can navigate through bookmarks to a specific cell or range of cells in a workbook.

Hyperlink documentation

Formulas

A wide range of formulas is available with cross-sheet references and named ranges support.

Spreadsheet Formulas

Built-in functions

The built-in calculation engine is preloaded with more than 200 Excel-compatible functions covering a broad range of business scenarios.

Auto calculations

Auto-calculation

Values are automatically recalculated when a dependent cell is edited.

Named ranges

Named ranges can be used in formulas as substitutes for cell references. The built-in name manager allows you to add, edit, and delete names.

Styles and data formatting

Cell Formatting

Font

Import and modify various font formatting options like font size, font family, font styles, font color, and fill color.

Spreadsheet font documentation

Font

Align and merge cells

Import and modify various horizontal and vertical alignments of text, merged cells, and wrap settings from Excel.

Merge cells documentation

Number formatting

Number formats

Import and modify number formats such as currency, percentage, short date, long date, time, fraction, and scientific number, similar to Excel.

Number formatting documentation

Table formats and built-in styles

Import table formats and predefined cell styles from Excel. You can also format a range as a table and define cell styles at runtime.

Cell styles documentation

Conditional formatting

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

Conditional Formatting in Spreadsheet

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.

Sort and Filter in Spreadsheet

Charts

Import charts from Excel that can be defined at runtime. This helps visually enhance the represented data.

Charts documentation

Charts in Spreadsheet

Sparklines

Import sparklines from excel to visually represent data in a row.

Sparklines documentation

Sparklines in Spreadsheet

Excel-like pivot table support

Summarize and analyze large amounts of data with pivot table support.

Pivot table documentation

excel like pivot table in Spreadsheet

Interactive features

Touch optimized

The ASP.NET Web Forms Spreadsheet control is touch-optimized for all user interactions, similar to Excel.

Spreadsheet selection

Excel-like selection

Select a range of cells, rows, columns, and tables. The Spreadsheet control also supports all keyboard interactions with selections.

cell comments

Cell comments

Import, add, edit, and delete cell comments.

Cell comments documentation

Spreadsheet contextmenu

There’s built-in support for cell and tab context menus. You can add custom context menu items.

Context menu documentation

Worksheet management

Row height and column width: Import row heights and column widths from Excel. Also fit rows and columns based on their content.
Insert and delete: Insert and delete rows and columns in a single worksheet in a workbook.
Hide and unhide: Hide and unhide rows and columns in a single worksheet in a workbook.
Gridlines: Customize the visibility of gridlines.
Headings: Control the visibility of row and column headers in a worksheet.
Sheets: Add one or more sheets and copy or move the existing sheets.

Protection

Encrypt workbooks with a password to prevent users from opening them.
Protect worksheets and restrict user actions like row and column insertion, deletion, and resizing.
Protect cells using a lock cell feature to restrict user editing action in selected cells.