The following are some of the main features of ComponentOne Excel for Silverlight that you may find useful:
•Save or load a workbook with one command
Excel for Silverlight 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. For example:
XLSheet sheet =
C1XLBook.Sheets[0];
sheet[0, 0].Value = DateTime.Now;
•Format the data in each cell.
The format associated with each cell is as easy to access as the data stored in the cell. For example:
XLStyle style = new
XLStyle(c1XLBook1);
style.Format = "dd-MM-yyyy";
style.Font = new
Font("Courier New", 14);
XLSheet sheet = C1XLBook.Sheets[0];
sheet[0,
0].Value = DateTime.Now;
sheet[0, 0].Style = style;
•Use Excel for Silverlight to export to XLSX files
Other ComponentOne components use Excel for Silverlight to export XLS files. For example, C1Report uses Excel for Silverlight to create XLSX versions of reports so they can be viewed and edited by anyone with a copy of Microsoft Excel.
•Reads and writes.xlsx files without using Microsoft Excel
Excel for Silverlight reads and writes .xlsx (OpenXml format) files, the 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 and load files to and from streams
Workbooks can now be directly read to and written from memory streams with new overloads for the Load and the Save methods so you no longer have to use temporary files.