Set custom BackgroundColor of a Excel sheet cell using epplus c#

Question

The problem:

I am using EEPlus.

I am stuck at applying a hex color code, e.g. #B7DEE8, for a cell in my Excel sheet.

I got the following (working) code:

ws.Cells["A1:B1"].Style.Fill.PatternType = ExcelFillStyle.Solid;
ws.Cells["A1:B1"].Style.Fill.BackgroundColor.SetColor(Color.Gray);

But I need something like the following:

ws.Cells["A1:B1"].Style.Fill.BackgroundColor.SetColor("#B7DEE8");

So my question is: is it possible to use hex color codes with EEPlus? If so, how can I do that?

score 140 · Accepted Answer · edited Sep 24 '17 at 17:18

140

Try this

Color colFromHex = System.Drawing.ColorTranslator.FromHtml("#B7DEE8");
ws.Cells["A1:B1"].Style.Fill.PatternType = ExcelFillStyle.Solid;
ws.Cells["A1:B1"].Style.Fill.BackgroundColor.SetColor(colFromHex);

edited Sep 24 '17 at 17:18

Walter Stabosz

7,447
5
43
75

answered Jun 08 '13 at 10:18

Yograj Gupta

9,811
3
29
48

I'm using Interop.Excel so I had to use range.Interior.Color but the color from HTML function was what I needed. – StevenWhite Jan 19 '15 at 20:58
`System.Drawing.ColorTranslator.FromHtml` is really what any one would need. – H Aßdøµ Apr 10 '20 at 11:26

score 28 · Answer 2 · answered Dec 05 '13 at 20:33

This is working well.

Dim objExcel As New ExcelPackage
Dim Sheet As ExcelWorksheet = objExcel.Workbook.Worksheets.Add("SheetName")
Sheet.Cells["A1"].Style.Fill.PatternType = Style.ExcelFillStyle.Solid
Sheet.Cells["A1"].Style.Fill.BackgroundColor.SetColor(Color.FromArgb(170, 170, 170))

score 6 · Answer 3 · answered Aug 16 '18 at 20:16

You are not obliged to translate a hexadecimal CSS color formula: You can simply put "0X" as a header of that number, which makes it an integer expression:

    var couleur = System.Drawing.Color.FromArgb(OXB7DEF8);
    Sheet.Cells["A1"].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
    Sheet.Cells["A1"].Style.Fill.BackgroundColor.SetColor(couleur);

score 1 · Answer 4 · edited Oct 20 '22 at 10:33

This worked for me.

//fill column A with solid red color from hex
worksheet.Column(1).Style.Fill.PatternType = ExcelFillStyle.Solid;
worksheet.Column(1).Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml("#FF0000"));

//fill row 4 with striped orange background
worksheet.Row(4).Style.Fill.PatternType = ExcelFillStyle.DarkHorizontal;
worksheet.Row(4).Style.Fill.BackgroundColor.SetColor(Color.Orange);

Set custom BackgroundColor of a Excel sheet cell using epplus c#

4 Answers4

Linked