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 Silverlight - you don't even need to have Microsoft Excel installed! Create and load 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 Silverlight includes one key component, C1XLBook. C1XLBook is easy to use, allowing 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 isolated storage 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 Silverlight reads and writes one primary format: XLSX (OpenXml format). 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 Silverlight 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 the easy API. 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.

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

    Other ComponentOne components use C1Excel to export XLSX files. For example, ComponentOne FlexGrid™ for Silverlight 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