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! Create or load XLS files. OpenXml format support allows you to save smaller, compressed XLSX files.

Features

  • Microsoft Excel Compatibility

    Just set one property, C1XLBook.CompatibilityMode, to specify which version of Microsoft Excel you want your workbooks to be compatible with. There are three options: Excel2003 (allows up to 64k rows and 256 columns), Excel2007 (up to 1 million rows and 18k columns), and NoLimits.

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

  • Microsoft Excel Independence

    Excel reads and writes XLS (Excel 97 and later) and XLSX (OpenXml format) files, the latter of which can be reused and easily exchanged or compressed to create smaller file sizes. You don't even need to have Microsoft Excel installed.

  • Save or Load a Workbook with One Command

    Excel is easy-to-use, allowing you to use a single command to load or save a workbook and manipulate sheets as if they were grid controls.

  • Read and Write Data in Individual Cells

    After loading or creating a C1XLBook, you can access data in individual sheets as if they were a simple grid.

  • Add Cell Formulas

    The XLCell.Formula property allows you to specify a formula for the cell.

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

  • Export to XLS Files

    Other ComponentOne components use Excel to export XLS files. For example, ComponentOne Reports™ for WinForms uses Excel to create XLS versions of reports so they can be viewed and edited by anyone with a copy of Microsoft Excel.

  • Place Images Exactly Where You Want Them within the Cell

    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.

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

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