The ASP.NET Core Spreadsheet, also known as the ASP.NET Core Excel viewer, is a feature-rich control for organizing and analyzing data in tabular format. It provides all the common Excel features, including data binding, selection, editing, formatting, resizing, sorting, importing, and exporting Excel documents.
Bind data seamlessly with various local and remote data sources such as JSON, RESTful services, OData services, and WCF services. The control uses a data manager to handle data and supports customizing data requests and processing.
The ASP.NET Core Spreadsheet (Excel like grid) component is designed and optimized for loading large amounts of data, scrolling, and more.
ASP.NET Core Excel Viewer instant loading allows users to load large amounts of data into a worksheet and view it on demand with the help of row and column virtualization.
The ASP.NET Core Spreadsheet control provides a smooth scrolling experience even with many cells in a view.
Data editing allows you to add, edit, and remove formulas or values in a cell. Edit the contents of a cell directly in the cell or by typing the formula bar.
The ASP.NET Core Spreadsheet widget provides interactive support to highlight the cells, rows, columns, and sheets selected. Selection can be done through mouse, touch, or keyboard interaction.
The ASP.NET Core Spreadsheet library provides a wide range of formulas with support for cross-sheet references.
The ASP.NET Core Spreadsheet with rich UI provides a built-in calculation engine is suitable for most of the calculations. Spreadsheet also provides an option to create and use custom formulas.
Values are automatically recalculated when a dependent cell is edited.
Number formatting is used to change the appearance of numbers in Spreadsheet. It helps display data as currency, percentages, short dates, long dates, time, fractions, and scientific numbers, similar to Excel.
Using cell formatting, users can highlight a particular cell or range of cells from a whole workbook. The control supports various formatting options: font size, font family, font color, fill color, indent, and horizontal and vertical alignments of text.
Load Excel documents initially or open them like an Excel application with data accuracy, styles, and formats. Microsoft Excel (.xlsx), Microsoft Excel 97-2003 (.xls), and comma-delimited values (.csv) file formats can be opened in a Spreadsheet.
Easily save the Spreadsheet component with data accuracy, styles, and formats as an Excel file. The ASP.NET Core Spreadsheet supports file formats such as Microsoft Excel (.xlsx), Microsoft Excel 97-2003 (.xls), and comma-delimited values (.csv).
There is built-in support for hyperlinks and bookmarks. Navigate to web links or cell references within the sheet or other sheets in the workbook.
The image feature allows users to view, insert, and modify a picture in a spreadsheet with customizing options.
The chart feature transforms the Spreadsheet data into an intuitive overview for better understanding.
The ASP.NET Core Spreadsheet provides an interactive ribbon that organizes the spreadsheet’s features into a series of tabs. Collapse the ribbon to make more rows visible in the viewport.
Easily collaborate on workbooks. Multiple users can work on a spreadsheet at the same time and view the changes made by others instantly.
Use the clipboard operations, cut, copy, and paste, just like Microsoft Excel. You can paste the values or formulas with or without formatting in a newly selected range.
The context menu improves user interaction with the Spreadsheet using a pop-up menu. It appears when a cell, row header, column header, or sheet tab is right clicked. In addition to built-in default menu items, you can add custom context menu items.
The resize and autofit options help you adjust the row height and column width.
The ASP.NET Core Spreadsheet provides an option to undo and redo changes made in a workbook. You can customize the limit of undo and redo operations.
The ASP.NET Core Excel Spreadsheet ensures that every cell is accessible using a keyboard. Major features like selection, clipboard, and editing can be performed using keyboard commands alone; no mouse interaction is required. This helps in creating highly accessible applications using this control.
The ASP.NET Core Excel-like grid view has complete WAI-ARIA accessibility support. The Spreadsheet UI includes high-contrast visual elements, helping visually impaired people have the best viewing experience. Also, valid UI descriptions are easily accessible through assistive technologies such as screen readers.
Five built-in, SASS-based themes are available: Material, Bootstrap, Bootstrap 4, Fabric, and high contrast. Simplify theme customization either by overriding the existing SASS styling or creating custom themes using the Theme Studio application.
The ASP.NET Core Spreadsheet enables users from different locales to use it by formatting the dates, currency, and numbering to suit their language preferences. It uses the internalization (i18n) library to handle number formatting.
Right-to-left rendering allows you to display the text and layout of the Spreadsheet from right to left. This improves the user experience and accessibility for RTL languages.
Localize all the strings used in the user interface of the ASP.NET Core Spreadsheet control. The control uses the localization (l10n) library to localize UI strings.
The ASP.NET Core Spreadsheet works well with all modern web browsers: Chrome, Firefox, Edge, Safari, and IE11. It supports IE11 with the help of polyfills.
Easily get started with the ASP.NET Core Spreadsheet using a few simple lines of C# code example as demonstrated below. Also explore our ASP.NET Core Spreadsheet Example that shows you how to render and configure a Spreadsheet ASP.NET Core.
@using Syncfusion.EJ2
@section ControlsSection{
<div class="control-section">
<ejs-spreadsheet id="spreadsheet" contextMenuBeforeOpen="createdHandler">
<e-spreadsheet-sheets>
<e-spreadsheet-sheet>
<e-spreadsheet-ranges>
<e-spreadsheet-range dataSource="ViewBag.DefaultData"></e-spreadsheet-range>
</e-spreadsheet-ranges>
<e-spreadsheet-columns>
<e-spreadsheet-column width="80"></e-spreadsheet-column>
<e-spreadsheet-column width="80"></e-spreadsheet-column>
<e-spreadsheet-column width="100"></e-spreadsheet-column>
<e-spreadsheet-column width="100"></e-spreadsheet-column>
<e-spreadsheet-column width="100"></e-spreadsheet-column>
</e-spreadsheet-columns>
</e-spreadsheet-sheet>
</e-spreadsheet-sheets>
</ejs-spreadsheet>
</div>
}
public IActionResult Index()
{
List<object> data = new List<object>()
{
new { OrderId= "SF1001", Product= "Laptop Backpack (Blue)", OrderedDate= "02/14/2014", OrderedBy= "Rahul Sharma", Shipment= "Delivered"},
new { OrderId= "SF1002", Product= "Oppo F1 S mobile back cover", OrderedDate= "06/11/2014", OrderedBy= "Adi Pathak", Shipment= "Delivered"},
new { OrderId= "SF1003", Product= "Tupperware 4 bottle set", OrderedDate= "07/27/2014", OrderedBy= "Himani Arora", Shipment= "Pending"}
new { OrderId= "SF1009", Product= "Listerine mouthwash", OrderedDate= "07/09/2014", OrderedBy= "Siddartha Mishra", Shipment= "Pending"},
new { OrderId= "SF1010", Product= "Protinex original", OrderedDate= "10/31/2014", OrderedBy= "Ravi Chugh", Shipment= "Delivered"},
};
ViewBag.DefaultData = data;
return View();
}
Spreadsheet is also available in Angular, React, Vue, and JavaScript frameworks. Check out the different Spreadsheet platforms from the links below,
Developers can customize their UI and control its behaviors according to the end user’s requirement using the control’s rich set of client-side APIs.
You can find our ASP.NET Core Spreadsheet demo here.
No, this is a commercial product and requires a paid license. However, a free community license is also available for companies and individuals whose organizations have less than $1 million USD in annual gross revenue and five or fewer developers.
A good place to start would be our comprehensive getting started documentation.
Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion is proud to hold the following industry awards.