Excel Library for .NET

Easy to use, allowing users to use a single command to load or save a workbook from your .NET code

Download Free Trial

Why Choose Excel Library for .NET?

A simple command away from any of your .NET apps

Load a workbook with a single command, and manipulate sheets as if they were grid controls composed of rows, columns, and cells. Then, save the workbook to an Excel file. OpenXML format support allows you to save smaller, compressed XLSX files.

Microsoft Excel Independence

ComponentOne Excel for .NET reads and writes two primary formats: XLS (Excel 97 and later) and XLSX (OpenXML format) files. You don't need to have Microsoft Excel installed.

Save and Load Workbooks with One Command

Workbooks — which can contain multiple sheets — can also be directly read to and written from memory streams, so you don't have to use temporary files. Macro-enabled Excel files are also supported.

Read and Write Data in Individual Cells

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

Format the Data in Each Cell

You can format cells to ensure that end users enter correct data. Access the format associated with each cell as easily as you access the data stored in the cell.

Grouping and Subtotals

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

Add Cell Formulas

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

Manage Cell Comments (Notes)

Add or edit cell comments in your Excel files using ComponentOne Excel for .NET. 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.

Accurately Match Colors with the Improved Color Palette

ComponentOne Excel for .NET uses HSB — hue, saturation, brightness — rather than RGB to map to the color palette, delivering a more accurate color match.

Globalization support

Excel for .NET supports right-to-left orientation in files.

Export to XLS, XLSX, and CSV Files

Other ComponentOne components use C1Excel to export XLS/XLSX files. For example, FlexReport uses Excel to produce Excel-compatible versions of reports so they can be viewed and edited by anyone with a copy of Microsoft Excel. The ASP.NET MVC version supports CSV exports, as well.

Save and Load Files To and From Streams

Workbooks can be directly read to and written from memory streams with new overloads for the C1XLBook.Load and the C1XLBook.Save methods, so you no longer have to use temporary files.

Add Images to Cells

Not only can you add images to cells, but you can also:

  • Specify the cell size
  • Define the position of the image within the cell
  • Scale, clip, or stretch the image to fit the cell

Not supported in UWP.

Add Images to the Header or Footer

Add images to the left, center, or right part of a sheet's header or footer using the properties in the XLPrintSettings class. Not supported in UWP.

Universal XLS Exporter

Other ComponentOne components use Excel for ASP.NET MVC to export XLS files. For example, FlexReport uses Excel for ASP.NET MVC to create XLS versions of reports so they can be viewed and edited by anyone with a copy of Microsoft Excel.