Close
Just a few details and you gain access to free downloads, support, subscription updates, betas, and special offers.
Join Now





Help Show Password

Read our Privacy Policy

Excel

Export your data to Excel with ComponentOne Excel™ for WPF - you don't even need to have Microsoft Excel installed! Create and load XLS and XLSX files with this easy to use component. Access and modify data in individual sheets as if they were a simple grid composed of rows, columns and cells.

Features

Show All
  • Save and Load Workbooks with One Command

    Excel for WPF includes one key component, C1XLBook. This easy-to-use component allows you to use a single command to load or save a workbook from your C#/VB.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. Modify an existing spreadsheet and save the changes.

  • Microsoft Excel Independence

    Excel for WPF 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 WPF 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 WPF. Cell comments (or notes) 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 (WriteableBitmap) 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 FlexGrid™ for WPF uses C1Excel to produce Excel-compatible versions of grids 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