Problem in setting back color


#1

Workbook excel = new Workbook();

excel.Worksheets.Add();

excel.Worksheets[0].Name = "DatamonitorTable";

excel.Worksheets[0].Cells[i ].Style.Pattern = BackgroundType.Solid;

excel.Worksheets[0].CellsIdea [I].Style.ForegroundColor = Color.FromArgb(159, 171, 210);

excel.Save("DatamonitorExcel.xls", Aspose.Cells.FileFormatType.Default , Aspose.Cells.SaveType.OpenInExcel, Response);

i tried this code its showing black color i am not able to see the data

its showing black color

where as i used Color.FromArgb(159, 171, 210); in aspose.word this color is getting effected

please help me how to set the color of the cell it is urgent


#2

Please check http://www.aspose.com/wiki/default.aspx/Aspose.Cells/ColorAndPalette.html .

Or you can use the following code to add a matching color in the standard palette:

excel.Worksheets[0].Cells[i ].Style.Pattern = BackgroundType.Solid;

excel.Worksheets[0].Cells[i ].Style.ForegroundColor = excel.GetMatchingColor(Color.FromArgb(159, 171, 210));