Your Excel data is just a simple command away from any of your .NET apps

You don't even need to have Microsoft Excel installed for ComponentOne Excel™ for .NET to work! 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

ComponentOne Excel is easy to use, allowing you to use a single command to load or save a workbook from your .NET code. 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.

One-command saving and loading

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:

Create multiple sheets

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

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)

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.

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.

Globalization support

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

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.

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.

Image Support

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.

Features

 WINFORMSWPFUWPMVC
Create and manage workbooks 
Save and load workbooks with one command
Read and write data in individual cells
Microsoft Excel independence
Format the data in each cell
Add cell formulas
Grouping and subtotals
Manage cell contents 
Image support
Add images to header or footer 
HSB color matching  
Export to XLSX or CSV files
Export to XLS (BIFF8) files  
Total Excel Compatibility 
Multiple Excel Versions supported
Save files to and from Streams