Spire.XLS

[ProPotsdam]

I would like to change the text color of a cell and get the following error messages:


sheet.Range["A10"].Style.Font.Color = Color.Red; //Error: CS0103: The name 'Color' does not exist in the current context
sheet.Range["A10"].Style.Font.Color = "FF0000"; //CS0029: Cannot implicitly convert type 'string' to 'System.Drawing.Color'

[Annika.Zhou]

Hello,

Thank you for your inquiry.
Regarding your request, please note that the Color reference you mentioned is from the System.Drawing library. Here is the complete code snippet that you can use:

Code: Select all

sheet.Range["A10"].Style.Font.Color = System.Drawing.Color.Red;
sheet.Range["A10"].Style.Font.Color = System.Drawing.Color.FromArgb(System.Convert.ToInt32("FF0000", 16));

Sincerely,
Annika
E-iceblue support team

[ProPotsdam]

Arrgh!
Sorry to have wasted your time...

using the Libary via codebehind it runs smoothly:

using Spire.Xls;
using System.Drawing;

...

public string officeExcel01(string _datensatz)
{
...

sheet.Range["A10"].Style.Font.Color = Color.Red;

...

}

Thanks for the hint ...

[Annika.Zhou]

Hello,

You're welcome.
If you encounter other issues related to our products in the future, please feel free to contact us.
Have a nice day.

Sincerely,
Annika
E-iceblue support team