I use this package: ExcelPackage though I can't figure out how to set the background color for the cell. I tried to use this:
ws.Cells["A1"].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
But it shows that the properties are not found.
Sounds like I should use something similar to this:
worksheet.Cell(5, columnIndex + 1).Style = "background-color: red";
But I am not sure how it works and I couldn't find the tutorial for it. Please help.
Select the cell or range of cells you want to format. Click Home > Format Cells dialog launcher, or press Ctrl+Shift+F. On the Fill tab, under Background Color, pick the color you want.
Try something along these lines (Taken from the EPPlus sample files provided):
using (var range = worksheet.Cells[1, 1, 1, 5])
{
range.Style.Fill.PatternType = ExcelFillStyle.Solid;
range.Style.Fill.BackgroundColor.SetColor(Color.DarkBlue);
}
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With