The Blazor Spreadsheet, a Blazor Excel viewer, is a feature-rich component for organizing and analyzing data in a tabular format, similar to Microsoft Excel, for web applications. It provides all the common Excel features, including importing and exporting Excel documents, selection, editing, formatting, sorting, filtering, resizing, protection, and more.
Get started with the Blazor Spreadsheet using a few simple lines of Razor code, as demonstrated in the following example. Also, explore our Blazor Spreadsheet example, which shows you how to render and configure a Spreadsheet in Blazor.
@using Syncfusion.Blazor.Spreadsheet
<SfSpreadsheet DataSource="DataSourceBytes" AllowAutofill="false">
<SpreadsheetRibbon></SpreadsheetRibbon>
</SfSpreadsheet>
@code {
public byte[] DataSourceBytes { get; set; }
protected override void OnInitialized()
{
// Sets the Excel file path for initial loading.
string filePath = "wwwroot/data/spreadsheet/sample.xlsx";
DataSourceBytes = File.ReadAllBytes(filePath);
}
}
A worksheet is a collection of cells arranged in rows and columns that lets users save, format, and work with data. Create, delete, and rename worksheets, and sheet visibility in the Blazor Spreadsheet.
Data editing allows users to add, edit, and remove formulas or values in a cell. The cell content can be edited in the cell or by typing directly into the formula bar.
Number formatting is used to change the appearance of numbers in the Blazor Spreadsheet. It helps display data as currency, percentages, short dates, long dates, time, fractions, and scientific numbers, similar to Excel.
Users can use cell formatting to highlight a particular cell or range of cells from a whole workbook. The component supports various formatting options: font size, font family, font color, fill color, indent, and horizontal and vertical text alignments.
Users can view, insert, and modify pictures in the Blazor Spreadsheet using customization options.
An interactive ribbon organizes the Spreadsheet’s features into a series of tabs.
The Blazor Spreadsheet user interface has been customized and redesigned for great views and usability on small screens.
Use the clipboard operations, cut, copy, and paste, just like Microsoft Excel. Users can paste values or formulas in a newly selected range.
The Spreadsheet component provides options to undo and redo changes made in a workbook.
The context menu improves user interaction in the Blazor Spreadsheet using a pop-up menu. It appears when a cell, row header, column header, or sheet tab is right-clicked.
The resize option helps adjust the row height and column width.
The Blazor Spreadsheet component provides a smooth scrolling experience even with many cells in view.
Load Excel documents initially via code or open them like an Excel application with data accuracy, styles, and formats. Microsoft Excel (.xlsx) and Microsoft Excel 97-2003 (.xls) file formats can be opened in a Blazor Spreadsheet.
Save the Blazor Spreadsheet component easily with data accuracy, styles, and formats as an Excel file. This component supports file formats such as Microsoft Excel (.xlsx) and Microsoft Excel 97-2003 (.xls).
The Blazor Excel Spreadsheet ensures that every cell is accessible using a keyboard. Major features like selection, clipboard, and editing can be performed using keyboard commands.
The Blazor Excel Spreadsheet has complete WAI-ARIA accessibility support. Its rich 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.
Right-to-left rendering allows the display of text and layout of the Spreadsheet from right to left. This improves the user experience and accessibility for RTL languages.
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.