Excel Font Color

Question

0.00/5 (No votes)

See more:

Hi,

I'm trying to obtain the font color and I tried to reverse how I set the color, however I'm getting an invalid cast exception. I'm not sure what I did wrong. Here's what I have:

C#

public System.Drawing.Color GetRangeFontColor(string range)
{
    System.Drawing.Color color;

    Excel.Range workingRangeCells = excelWorksheet.get_Range(range, Type.Missing);
    color = (System.Drawing.Color) workingRangeCells.Font.Color;

    return color;
}
public void SetRangeFontColor(string range, System.Drawing.Color color)
{
    Excel.Range workingRangeCells = excelWorksheet.get_Range(range, Type.Missing);
    workingRangeCells.Font.Color = System.Drawing.ColorTranslator.ToOle(color);
    return;
}

Thank you for help! :)

Posted 28-Jul-10 3:21am

gmhanna

Updated 28-Jul-10 5:57am

Nuri Ismail

v2

Add a Solution

2 solutions

Solution 2

Hi,

I have tried what you suggested and now I'm receiving a specified cast not valid when trying to cast workingRangeCells.Font.Color to an int. workingRangeCells.Font.Color returned an Object before I casted it. ColorTranslator.FromOle wants an (int).

color = ColorTranslator.FromOle((int) workingRangeCells.Font.Color);

Thank you,

Posted 28-Jul-10 3:52am

gmhanna

Comments

Nuri Ismail 28-Jul-10 11:18am

You should convert the Color to integer instead of casting it. I will update my answer in order to show you how.

PS: It's better to post a comment or edit your original question for such clarifications instead of posting "fake answers". This improves forum readability.

:)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Nuri Ismail · Accepted Answer · 2010-07-28T03:29:00

Use the ColorTranslator[^] class instead of typecast. You'll have to use its FromOle[^] method in order to convert the OLE color value to GDI+ Color. :)

[UPDATE]
ColorTranslator.FromOle method requires an integer as parameter. So you'll need to convert from Range.Font.Color to int. Instead of using a typecast, try with Convert.ToInt32[^] method.

I've made a test and the following code works fine for me:

C#

Excel.Range workingRangeCells = excelWorksheet.get_Range(range, Type.Missing);
System.Drawing.Color color = System.Drawing.ColorTranslator.FromOle(Convert.ToInt32(workingRangeCells.Font.Color));

[/UPDATE]

:)