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

Show All
  • 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.

  • 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

    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

    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.

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

  • 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

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

As a leading component vendor in the Microsoft Visual Studio Industry Partner program, ComponentOne has been providing the widest range of Microsoft Visual Studio components, IDE platform development tools, and applications for over 22 years. ComponentOne product lines encompass custom WinForms, ASP.NET, WPF, Silverlight, Mobile, and COM components, documentation tools, and Web Parts for Microsoft Office SharePoint Server and Windows SharePoint Services.

Contact ComponentOne: 1.800.858.2739 | Pittsburgh: 412.681.4343

©2012 ComponentOne LLC All Rights Reserved.
All product and company names herein may be trademarks of their respective owners.
ComponentOne holds a license under Patent No. 5,490,216 (which expires on September 21, 2013)

ComponentOne