Excel cells coloring

Question

I have this sheet in excel called Export and I want its header to be gray. Here is the code:

 protected void btnExcel_OnClick(object sender, EventArgs e)
 {
      var ex = new Aspose.Cells.Workbook();
      ex.Worksheets.Clear();
      Aspose.Cells.Worksheet ws = ex.Worksheets.Add("Export");
      ws.Cells.ImportTable(Export.GetExportList(GetWhereClause(), ConfigurationManager.AppSettings();
      ws.Cells[0, 0].PutValue("A");
      ws.Cells[0, 1].PutValue("B");
      ws.Cells[0, 2].PutValue("C");
      ws.Cells[0, 3].PutValue("D");
      ws.Cells[0, 4].PutValue("E");
      var style = ws.Cells.Rows[0].Style;
      style.Font.IsBold = true;
      ws.Cells.Rows[0].ApplyStyle(style, new StyleFlag { FontBold = true });
      ex.Save(string.Format("Export_{0}.xlsx", DateTime.Now.ToString("yyyyMMdd_HHmmss")), FileFormatType.Excel2007Xlsx, SaveType.OpenInExcel, Response);
}

I included the button code as well. I have tried something like this:

style.BackgroundColor = Color.DarkGrey;

or

ws.Cells[0, 0].Style.BackgroundColor = Color.DarkGrey;

And I don't have the .Interior method.Nothing works. What can I do?

What do you mean by "nothing works"? What exactly doesn't work? — haindl, Oct 12 '16 at 13:27
have you tried setting style to cells individually? like this ws.Cells[0,0].SetStyle(style); — Karthik Ganesan, Oct 12 '16 at 13:28
@haindl the lines of code I tried above. The color doesn't appear at all. — Jess Wss, Oct 12 '16 at 13:29
did you try the method here http://stackoverflow.com/questions/17696458/how-to-set-color-for-header-or-first-row-in-excel? — Jacobr365, Oct 12 '16 at 13:29
When you say you don't have the interior method do you mean Range.Interior or Style.Interior ??? — J Reid, Oct 12 '16 at 13:41

Slai · Answer 1 · 2016-10-12T13:57:18.580

0

From the docs: http://www.aspose.com/docs/display/cellsnet/Colors+and+Background+Patterns

Style style = worksheet.Cells["A1"].GetStyle();
style.BackgroundColor = Color.Yellow;
worksheet.Cells["A1"].SetStyle(style);

edited Oct 12 '16 at 13:57

answered Oct 12 '16 at 13:46

Slai

22,144
5
45
53

Prorata · Accepted Answer · 2016-10-13T12:34:22.297

@Jess Wss,

Please check the following piece of code to apply the cell shading on 1st row of the spreadsheet. Please note, there are two issues in your code.

In case you wish to apply the cell shading, you have to set the Style.Pattern property as well.

You also require to turn on the relevant StyleFlag property. In this case, the StyleFlag.CellShading has to be true before applying the style.

var style = ws.Cells.Rows[0].Style;
style.Font.IsBold = true;
style.ForegroundColor = System.Drawing.Color.LightGray;
style.Pattern = BackgroundType.Solid;
ws.Cells.Rows[0].ApplyStyle(style, new StyleFlag { FontBold = true, CellShading = true });

Note: I work with Aspose as Developer Evangelist.

Excel cells coloring

2 Answers2