How to set custom colors to cell in Excel spreadsheet in .NET

Aspose.Cells Product Family
1

I've got the following problem:

Dealin' with Excel Application object I can set

cell's interior color via colorindex like this

range.Interior.ColorIndex=colorindex;

And in Aspose.Excel I've got a style object,

but settin' up ForegroundColor property does not help-

style.ForegroundColor=Color.[SomeColor]

range.Style=style

But I get black ForegroundColor almost all times and only few members of color work!!Angry [:@]

Do u have any solution?Sad [:(]

2

Please check Color and Palette for reference.

If the color is not in the standard palette, please change the palette first. And you can use Excel.IsColorInPalette method to check if a color is in standard palette.

3

Thanks a lot, Laurence - it really works!!