Excel for .NET provides the following essential features in order to facilitate the creation of powerful spreadsheets using .Net:

Cross-Platform Support

.NET Standard version of Excel is supported for .NET 6+ applications including WinForms, WPF, WinUI and ASP.NET Core.

No Dependency on MS Excel

In order to work with Excel for .NET, you don't need to install MS Excel on your systems. Excel reads and writes two primary formats: XLS and XLSX (OpenXML).

Based on Excel Object Model

The interface-based API model enables users to import data, calculate formulas, query, generate, and export complex spreadsheet scenarios as per specific preferences.

Workbook and Worksheets

You can create workbook and add worksheets while also performing the import and export operations. Additionally, you can customize the view layouts of worksheets in a workbook.

Shapes and Pictures

With Excel for .NET, you can insert and customize shapes and pictures on cells of a worksheet, apply formatting, configure text, insert hyperlinks, and much more.

Format the data in each cell

The format associated with each cell is as easy to access as the data stored in the cell.

RTF Support

Excel for .NET now fully supports the Rich Text Format (RTF) for both text and graphics interchange formats that can be used with different operating systems, environments and output devices.

Work with Macros

Excel for .NET also enables you to work with macro-enabled Excel files (XLSM). It supports OpenXMLMacro File Format which can be used to save/load Macros based files in C1Excel.

Formulas

Excel lets you execute complex spreadsheet calculations without any hassle by implementing formulas.

Work with Images

Not only can you add images to cells, but now you can specify the image size, the position of the image within the cell and whether the image is scaled, clipped, or stretched to fit the cell.

Save and Load files directly

Excel for .NET provides a single command to load or save a workbook and manipulate its sheets. Additionally, workbooks can now be directly read to and written from memory streams with the overloads of the Load and the Save methods so you do not need to use temporary files. For more information, see Load and Save.