ExpertXls Excel Library Blazor demo · .NET 10 and .NET 11

Demos

Each link creates the workbook of a demo in the Excel 97-2003 (.xls) or Excel 2007+ (.xlsx) format. The code of the demos is in the Features folder; the download endpoints are in WorkbookEndpoints.cs.

DemoWhat it showsDownloadCode
Getting Started Named cell styles, page setup, merged cells, pictures, formulas, a chart, a named range and hyperlinks. .xls .xlsx C#
Cells and Ranges The A1 notation, row and column indexes, named ranges and the used range. .xls .xlsx C#
Cell Styles Named styles, solid, pattern and gradient fills, alignment, text rotation, fonts and borders. .xls .xlsx C#
Data Types and Formats Text, numbers, dates and booleans with Excel number and date formats. .xls .xlsx C#
Images Pictures at real size, scaled, stretched over a range and loaded from a file. .xls .xlsx C#
Formulas Formulas, array formulas, named ranges in formulas, results calculated by the library. .xls .xlsx C#
Data Validation Drop-down lists, whole numbers, dates, text length and decimals, with input messages and error alerts. .xls .xlsx C#
Conditional Formatting Cell value and formula rules, a color scale, data bars, an icon set and, in .xlsx, sparklines. .xls .xlsx C#
Sort and Filter A table sorted by two columns, AutoFilters by values, a number condition and text conditions. .xls .xlsx C#
Excel Tables An Excel table with a built-in style, filter buttons and a totals row (.xlsx; the .xls gets an AutoFilter). .xls .xlsx C#
Find and Replace Cells found in a worksheet and in the workbook, texts replaced matching the case or the whole cell. .xls .xlsx C#
DataTable Import and Export A worksheet read into a DataTable and the DataTable loaded into a new workbook. .xls .xlsx C#
CSV Import A CSV file imported into a new workbook and formatted. .xls .xlsx C#
Edit a Workbook An existing workbook opened, changed and saved as a new workbook. .xls .xlsx C#
Workbook Security A protected worksheet with unlocked input cells, a hidden formula and a protected workbook structure. .xls .xlsx C#

Charts

Adds charts with series generated from a data range or added one by one, and a chart worksheet.

  

Download .xls   Download .xlsx   C# code

Create, edit and read Excel workbooks in a Blazor application: the workbooks are created on the server and downloaded by the browser. The code of each workbook is in the Features folder.