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, WinUI, UWP, Blazor, and ASP.NET MVC applications
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.
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 |
WinUI/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 |
- | ||
