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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Overview

The ASP.NET Core 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.


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 Core 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 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.

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.

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.

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.

hyperlinks and bookmarks for spreadsheet

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.


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

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.

Font

Align and merge cells

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

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.

Table formats and built-in styles

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.


Conditional formatting

In ASP.NET Core 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 in Spreadsheet


Sparklines

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

Sparklines in Spreadsheet


Excel-like pivot table support

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

excel like pivot table in Spreadsheet


Interactive features

Touch optimized

Touch optimized

The ASP.NET Core 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.

Spreadsheet contextmenu

Context menu

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


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.

Conversion and printing

  • Convert imported Excel workbooks to other formats like CSV or PDF.
  • Print the Excel workbook.

Conversion in Spreadsheet


Localization

Localize all static text in the ribbon and built-in dialogs of a spreadsheet to any supported language.

Spreadsheet localization


70+ ASP.NET CORE 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