I need to use diffrent color as cell forground color. But I can use only Red, Green, Blue etc.
Is there any limitation for this. I can’t use all System.Color.
Thanks for considering Aspose.
Well, there is no limitation for setting colors. I think the color your are applying might not be present in the Excel Standard Color Palette, so you have to add it first into the palette before setting it as a fill color of a cell. Since the Excel color palette has only 56 colors (0-55 indexed) on it, so if a color is not there, you will add the color to the palette replacing any existing color on a specified index position using Workbook.ChangePalette() method.
Here is a sample code for your need:
//Instantiating a Workbook object
Workbook workbook = new Workbook();
// Add sky blue color to the palette.
//Obtaining the first worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets;
//Now setting the foreground color of the "A1" cell to sky blue
worksheet.Cells["A1"].Style.ForegroundColor = Color.SkyBlue;
//Setting the background pattern of the "A1" cell to solid
worksheet.Cells["A1"].Style.Pattern = BackgroundType.Solid;
//Saving the Excel file
For further ref, please check the following: