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.
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 be directly read to and written from memory streams too, so you don't have to use temporary files.
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.
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 even need to have Microsoft Excel installed! OpenXml format allows you to save smaller, compressed files.
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.
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.
Grouping and Subtotals
Calculate subtotals for rows and columns. Declare outline level grouping in code to best display totals 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.
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.
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.
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 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.