Your Excel data is just a simple command away from any of your .NET apps with ComponentOne Excel™ for ASP.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
-
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.
-
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.
-
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
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.
-
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.
-
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.
-
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 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.