Skip to main content Skip to footer

Easy-to-Use .NET Excel Library

Create, open and modify Excel files from your .NET code with ComponentOne Excel for .NET.

  • Load existing Excel files or create new ones
  • Add sheets, styles, hyperlinks, images, headers and footers, page breaks and more
  • Supports .NET Framework, .NET 6+, WinForms, WPF, UWP, Blazor, and ASP.NET MVC applications
Download Free Trial

Why Choose ComponentOne Excel?

Export Any Data to Excel

Export any dataset from your application to Microsoft Excel files. Anyone with a copy of Excel can access your data. It's that easy!

Load or Edit Existing Workbooks

Open and modify your existing Excel files through C# or VB.NET code to access or insert additional data.

Quickly Style Apps

Easy to Use

Manipulate sheets as if they were grid controls composed of rows, columns, and cells. Load or save your workbook to a stream with a single command.

No Dependencies on Excel

ComponentOne Excel reads and writes two primary formats: XLS and XLSX (OpenXML). You and your users don't need to have Microsoft Excel installed.

Cross-Platform Support

A .NET Framework version of C1Excel is supported for WinForms, WPF, ASP.NET MVC and UWP applications.

Target Any .NET Platform

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

.NET Excel Key Features

Read and Write Data in Individual Cells

After loading into or creating an Excel Workbook, you can access data in individual sheets as if they were a simple grid composed of rows, columns and cells.

XLSheet sheet = C1XLBook.Sheets[0];
sheet[0, 0].Value = "Cell Value";
XLStyle style = new XLStyle(c1XLBook1);
style.Format = "dd-MM-yyyy";
XLSheet sheet = C1XLBook.Sheets[0];
sheet[0, 0].Value = DateTime.Now;
sheet[0, 0].Style = style;

Format the Data in Each Cell

You can format cells to best display each cell containing numbers, dates and percentages. Access the format associated with each cell as easily as you access the data stored in the cell.

Additional Features

Read and Write XLS & XLSX Files

ComponentOne Excel for .NET reads and writes .XLS (Excel 97 and later) and .XLSX (OpenXml) files. You can also save to CSV. You don't even need to have Microsoft Excel installed.

Grouping and Subtotals

Calculate subtotals for rows and columns. Declare outline level grouping in code to best display totals and subtotals.

Cell Formulas

Our .NET Excel library fully supports cell formulas and binary parsing. The XLCell.Formula property allows you to specify a formula for the cell.

Cell Images

Add images to cells and specify the size, position, and scale, clip, or stretch the image to fit the cell. You can also add images to the sheet's header or footer. The .NET Framework version supports metafiles.

Cell Comments (Notes)

Add or edit cell comments in your Excel files. Cell comments — also called notes — in Excel allow you to attach a comment to a cell to inform, remind, or explain the content of a cell or range of cells.

Supports Macros Enabled Files

Excel for .NET can save and load Macros-enabled Excel files (*.xlsm). The VBA code can be loaded in binary format into xlsm files.

.NET Excel Platform Comparison

Feature

WinForms

WPF

UWP

ASP.NET MVC

Create and save workbooks

Load existing workbooks

Read and write data in individual cells

Format the data in each cell

Add cell formulas

Grouping and subtotals

Manage cell contents

Image support (including metafiles)

Add images to header or footer

HSB color matching

Save to XLSX or CSV files

Save to XLS (BIFF8) files

Multiple Excel Versions supported

Save files to and from Streams

Support for charts, PDF export, report templates and other features

Check out Document Solutions for Excel

-