| Live Chat   Login |  Join
   
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.

Doc-To-Help enables technical communicators, policy writers, and other content creators to author in Doc-To-Help's XML-based editor, Microsoft Word or HTML, (or use existing documents) and publish to the Web (via ComponentOne NetHelp®), Help systems, or printed manuals with a single click. Doc-To-Help is developed by ComponentOne, the makers of Studio Enterprise, a suite of components for Visual Studio.

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)

Contact ComponentOne: 1.800.858.2739 | Pittsburgh: 412.681.4343 Twitter Facebook

©2013 GrapeCity, inc. All Rights Reserved.
Includes ComponentOne NetHelp® Technology