Setting the color of a cell (or row)

Topics: Developer Forum, User Forum
Oct 15, 2011 at 10:10 PM
Edited Oct 15, 2011 at 10:11 PM

How can I set the color of a cell when using ExcelPackage?

For example, I want to set the color to grey for row ("A8:E8").

I am using vb.net Visual Studio 2008

 

Thanks

Jan 16, 2012 at 5:25 AM
Edited Jan 16, 2012 at 5:26 AM

ws.Cells[row, 1].Value ="Sample Text";

ws.Cells[row, 1].Font.Color = System.Drawing.Color

.Blue;

ws.Cells[row, 1].Font.Bold =true

;

ws.Cells[row, 1].Font.Size = 12;