facebooktwittermenuarrow-up

GemBox Support Forum

How to set a row background color

How can I specify a ROW and set a background color to Green, Accent6Lighter60Pct?

I found the above values in one of your ColorName but can’t put this together to set a specified row to that background color.

Hi Herb,

Try this:

var workbook = new ExcelFile();
var worksheet = workbook.Worksheets.Add("Sheet1");

var color = SpreadsheetColor.FromName(ColorName.Accent6Lighter60Pct);
worksheet.Rows[0].Style.FillPattern.SetSolid(color);

workbook.Save("output.xlsx");

Does this solve your issue?

Regards,
Mario

Excellent, that works!
Thank you Mario.