Cell styles in SpreadsheetGear C# .NET

Question

I try create excel document via SpreadsheetGear. And i would like to apply some styles on headers?fonts etc same as on screenshot:

I wrote the following code:

 static string[] fieldsName =
    {
        "Name",
        "LastName",
        "Address",
        "Phone"

    };       
private static void Main(string[] args)
 {
        var workbook = Factory.GetWorkbook();
        IWorksheet worksheet = workbook.ActiveWorksheet;
        IRange cells = worksheet.UsedRange;
        cells["A1:C1"].Style.Font.Bold = true;
        cells["A1:C1"].Font.Color = Color.FromArgb(255, 255, 255);
        cells["A1:C1"].Interior.Color = Color.FromArgb(0, 204, 0);

        cells["A1"].Value = " ";
        cells["B1"].Value = "My demo excel file";
        cells["C1"].Value = " ";

        cells["A2:C2"].Style.Font.Bold = true;
        cells["A2"].Value = "Field";
        cells["B2"].Value = "Description";
        cells["C2"].Value = "Value";
       
        FillDecisionCells(cells);
        
        workbook.SaveAs(@"D:\test.xlsx", FileFormat.OpenXMLWorkbook);
 }

Then I try to fill Field column without bold font style:

private static void FillDecisionCells(IRange cells)
    {
        for (var i = 2; i < fieldsName.Length; i++)
        {
            cells[i, 0].Value = fieldsName[i];
        }
    }

But end up with all the text in bold:

score 3 · Accepted Answer · answered Jun 24 '21 at 21:51

See https://stackoverflow.com/a/28533330/233365 for an explanation for this. But bottom-line, you need to set the cell’s font directly such as…

cells["A2:C2"].Font.Bold = true;  // Good

…and not the cell’s style’s font:

cells["A2:C2"].Style.Font.Bold = true;  // Bad

Setting the cell’s style will affect all other cells using that same style, which in the case of the “Normal” style (probably the style being set in your case) is usually most if not all other cells. Hence bold everywhere.

Cell styles in SpreadsheetGear C# .NET

1 Answers1