How do you set the font color in an EXCEL cell?

[Guest]

Where xlWs is an Excel.Worksheet and xlRG is an Excel.Range


xlRG = xlWS.Cells(row, 7)
xlRG.Font.Bold = True
xlRG.Font.Color = 255

In VB6 you could just simply say xlRG.Font.Color = vbRed but in .net there
is no constant vbRed and Color.Red gives an invalid format. Is there a set of
enumerations of colors that will work here?

 

[Cor Ligthert]

Darrell,

I am in doubt if it is the same colourcode as the Interop wants, however a
colour in VBNet is just easy to get with Color.Red (it is a enum so a bunch
of colours is showed)

I hope this helps?

Cor

 

[Frank Liebelt]

Hi

xlRG = xlWS.Cells(row, 7)
xlRG.Font.Bold = True
xlRG.Font.Color = 255

Excel-Workbook:
xlWB.Colors(1) = RGB(255,255,255)
xlWB.Colors(2) = RGB(225,225,225)
xlWB.Colors(3) = RGB(200,200,200)

Excel-Worksheet
xlWS.Range("A1:A30").Interior.ColorIndex = 1
xlWS.Range("B1:B30").Interior.ColorIndex = 2
xlWS.Range("C1:C30").Interior.ColorIndex = 3

This works fine for me

Frank

 

[Adel Al-saleh]

Where xlWs is an Excel.Worksheet and xlRG is an Excel.Range


xlRG = xlWS.Cells(row, 7)
xlRG.Font.Bold = True
xlRG.Font.Color = 255

In VB6 you could just simply say xlRG.Font.Color = vbRed but in .net there
is no constant vbRed and Color.Red gives an invalid format. Is there a set of
enumerations of colors that will work here?

Hi Darrell,

What was the exact message? May it is a casting problem.


TTH,
Adel A. Al-saleh

 

[Guest]

Finally found out how to do this:

xlRG.Font.Color = System.Drawing.Color.ColorTranslator.ToOle(Color.Red)

and to set the cell background color

xlRG.Interior.Color =
System.Drawing.Color.ColorTranslator.ToOle(Color.LightBlue)
xlRG.Interior.Pattern = Excel.XlPattern.xlPatternSolid

 

[Cor Ligthert]

Darrel,

Thanks for sending this feed back.

However I did not understand why I had not seen it before in the intelisence
of the color and searched for it on MSDN.

And than I saw this.
http://msdn.microsoft.com/library/d...stemDrawingColorTranslatorClassToOleTopic.asp

And not as a method of color

http://msdn.microsoft.com/library/d.../html/frlrfsystemdrawingcolormemberstopic.asp

Therefore are you sure that it works as you describe it.

Cor

 

[Guest]

YES.

If you try to set the ColorIndex property you will get an error.

Take a look at this

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_vsto2003_ta/html/ExcelObj.asp

 

[Cor Ligthert]

Darell,

Thanks for the page, however there it is not described as you did it.

Colorconverter is a method from system.drawing not from
system.drawing.color.

Cor

 

[Guest]

You are so right. Thanks.

Darell,

Thanks for the page, however there it is not described as you did it.

Colorconverter is a method from system.drawing not from
system.drawing.color.

Cor