Setting the color of a cell using ExcelPackage

Question

I am using vb.net and I have an asp.net application where I use ExcelPackage. I wanted to know how to set the background color of a particular cell or a row of cells.

score 3 · Answer 1 · answered Mar 13 '13 at 14:25

I know this question is old but here is the answer:

ExcelPackage pck = new ExcelPackage();
ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Example");
string index= "A1";
ws.Cells[index].Style.Fill.PatternType = ExcelFillStyle.Solid;    
ws.Cells[index].Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.Orange);

Please note that you must set the PatternType before you can set a background color or an exception is thrown.

Sorry but my example is c#, you will need to convert to VB.Net to be 100% correct for the question!

It seems you can also use a range: `ws.Cells["A1:B7"]`. Also see http://stackoverflow.com/questions/17156118/how-to-set-color-or-background-with-excelpackage#17157666. — SharpC, Jan 25 '16 at 18:18

score 3 · Accepted Answer · answered Oct 15 '11 at 22:24

3

I recommend you use the component Epplus, it is quite complete and need not be installed on production server.

http://epplus.codeplex.com/releases/view/42439

answered Oct 15 '11 at 22:24

Vicente Jr

237
1
3

Setting the color of a cell using ExcelPackage

2 Answers2