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.
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.
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.
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.
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
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.
|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||✔||✔||✔|
|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||✔||✔||✔||✔|