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.
| Demo | What it shows | Download | Code | |
|---|---|---|---|---|
| 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.