Closed XML

C# Corner

Closed XML

sathish

3y1.1kC#

Hi,

How to set the background color in closed xml (C#)

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Pankajkumar Patel3y ago

Accepted answer

Hi Sathish,

To set the background color in closed xml in C#:

using ClosedXML.Excel;

using var wbook = new XLWorkbook();

var ws = wbook.Worksheets.Add("Sheet1");

ws.Range("D2:E2").Style.Fill.BackgroundColor = XLColor.Gray;
ws.Ranges("C5, F5:G8").Style.Fill.BackgroundColor = XLColor.Gray;

For more details:

C# Excel
- https://zetcode.com/csharp/excel/

Hope this will help you!