Part of Studio for WinForms Excel for .NET

Your Excel data is just a simple command away from any of your .NET apps with ComponentOne Excel™ for .NET – you don't even need to have Microsoft Excel installed! Load a workbook with a single command, 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.

Features

Save and Load Workbooks with One Command

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 be directly read to and written from memory streams too, so you don't have to use temporary files. Save and Load Workbooks with One Command

Read and Write Data in Individual Cells

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

Microsoft Excel Independence

Excel for .NET reads and writes two primary formats: XLS (Excel 97 and later) and XLSX (OpenXml format) files. You don't even need to have Microsoft Excel installed! OpenXml format allows you to save smaller, compressed files. Microsoft Excel Independence

Format the Data in Each Cell

You can format cells to ensure that end-users enter correct data. The format associated with each cell is as easy to access as the data stored in the cell. Format the Data in Each Cell

Add Cell Formulas

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

Grouping and Subtotals

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

Manage Cell Comments (Notes)

Add or edit cell comments in your Excel files using ComponentOne Excel for .NET. Cell comments (or 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. Manage Cell Comments (Notes)

Image Support

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

Add Images to the Header or Footer

Properties in the XLPrintSettings class allow you to add images to the left, center, or right part of a sheet's header or footer. Add Images to the Header or Footer

Accurately Match Colors with the Improved Color Palette

Excel uses HSB (hue, saturation, brightness) rather than RGB to map to the color palette, delivering a more accurate color match. Accurately Match Colors with the Improved Color Palette

Export to XLS or XLSX Files

Other ComponentOne components use C1Excel to export XLS/XLSX files. For example, ComponentOne Reports™ for WinForms uses C1Excel to produce Excel-compatible versions of reports so they can be viewed and edited by anyone with a copy of Microsoft Excel. Export to XLS or XLSX Files

Resources

Whether you are a customer or just trying us out, we stand behind you. Valuable learning resources such as samples, videos, and forums are free and just a click away.

Ready to start your 30-day, risk-free trial?

Includes free technical support.

Ready to buy?

All licenses are developer-based and there are no limits on the distribution of applications–unlimited, royalty-free, run-time distribution.

Pricing

Need help deciding?

Chat with sales, call or email. We're here to answer all your questions.

1.800.858.2739 | 412.681.4343 sales@componentone.com

Chat with Sales