Download LiteExcel from codeplex ( my open source silverlight library for manipulating MS excel without COM interaction).
Add reference of “Lite.Library.dll” and “Lite.ExcelLibrary” to your Silverlight project.
Refere “Lite.ExcelLibrary.SpreadSheet” on the top of your Silverlight page.
using Lite.ExcelLibrary.SpreadSheet;
Writing an excel file
// open file dialog to select an export file.
SaveFileDialog sDialog = new SaveFileDialog(); sDialog.Filter = "Excel Files(*.xls)|*.xls"; if (sDialog.ShowDialog() == true) { // create an instance of excel workbook Workbook workbook = new Workbook(); // create a worksheet object Worksheet worksheet = new Worksheet("Friends"); // write data in worksheet cells
worksheet.Cells[0, 0] = new Cell("Column1"); worksheet.Cells[0, 1] = new Cell("Column2"); worksheet.Cells[0, 2] = new Cell("Column3"); worksheet.Cells[1, 0] = new Cell("string value"); worksheet.Cells[1, 1] = new Cell(478574.5, "#,###.00"); worksheet.Cells[1, 2] = new Cell(4);
workbook.Worksheets.Add(worksheet);
Stream sFile = sDialog.OpenFile();
// save method needs a stream object to write an excel file.
workbook.Save(sFile);
}