Excel for WPF | ComponentOne
QuickStart: Excel for WPF / Step 3 of 4: Formatting the Content
In This Topic
    Step 3 of 4: Formatting the Content
    In This Topic

    Next we will format the content using styles. The code in this step should be added after the code from Step 2 of 4.

    1. Add the following code to create two new styles: stye1 and style2.
      Visual Basic
      Copy Code 
      ' Add style 1.
Dim style1 As New XLStyle(book)
style1.Font = New XLFont("Tahoma", 9, true, false)
style1.ForeColor = Colors.RoyalBlue
' Add style 2.
Dim style2 As New XLStyle(book)
style2.Font = New XLFont("Tahoma", 9, false, true)
style2.BackColor = Colors.RoyalBlue
style2.ForeColor = Colors.White

       

      C#
      Copy Code 
      // Add style 1.
XLStyle style1 = new XLStyle(book);
style1.Font = new XLFont("Tahoma", 9, true, false);
style1.ForeColor = Colors.RoyalBlue;
// Add style 2.
XLStyle style2 = new XLStyle(book);
style2.Font = new XLFont("Tahoma", 9, false, true);
style2.BackColor = Colors.RoyalBlue;
style2.ForeColor = Colors.White;
    2. Then add the following code to apply the new styles to the content.
      Visual Basic
      Copy Code 
      For i = 0 To 9
    ' Apply styles to the content.
    If (i + 1) Mod 2 = 0 Then
        sheet(i, 0).Style = style2
        sheet(i, 1).Style = style1
        sheet(i, 2).Style = style2
    Else
        sheet(i, 0).Style = style1
        sheet(i, 1).Style = style2
        sheet(i, 2).Style = style1
    End If
Next i

       

      C#
      Copy Code 
      for (i = 0; i <= 9; i++)
            {
                // Apply styles to the content.
                if ((i + 1) % 2 == 0)
                {
                    sheet[i, 0].Style = style2;
                    sheet[i, 1].Style = style1;
                    sheet[i, 2].Style = style2;
                }
                else
                {
                    sheet[i, 0].Style = style1;
                    sheet[i, 1].Style = style2;
                    sheet[i, 2].Style = style1;
                }
            }