Formatting Cells

To format the cells of a book, complete the following steps:

1. Add a reference to C1.WPF.Excel.dll or C1.Silverlight.Excel.dll and create a C1XLBook.

   // Create a new workbook to be saved
   C1XLBook book = new C1XLBook();
   

2. Add some content to the workbook, create a new style and apply the styles to the cells in the first column of the sheet.

   // Create a new style
    XLStyle style1 = new XLStyle(book);
    style1.ForeColor = Colors.Yellow;
    style1.BackColor = Colors.Blue;
    style1.Format = "$ .00";
   // Add content and apply styles to cells in first column of sheet
     XLSheet sheet = book.Sheets[0];
           int i;
           for (i = 0; i <= 9; i++)
             {
               sheet[i, 0].Value = i + 1;
               sheet[i, 0].Style = style1;
              }
   

3. Save and open the workbook.

   // Save and open the file
   book.Save(@"C:\test.xls");
   System.Diagnostics.Process.Start(@"C:\test.xls");