Help in the excel

[Pranjal Jain]

HI All
I want to insert the data into the Excel sheet, but I wish the data to
be inserted in Excel Sheet is not in black color but in green color.
I had tried the following code for it, but it is not working.

Can anybody has the solution for it.

$worksheet.Range("c#{b+1}").Value = "Login page
verified.".colorizegreen)
puts "\nWeb page opened successfully\n".colorizegreen)

Thankx in advance

 

[David Mullet]

HI All
I want to insert the data into the Excel sheet, but I wish the data to
be inserted in Excel Sheet is not in black color but in green color.
I had tried the following code for it, but it is not working.

Can anybody has the solution for it.

$worksheet.Range("c#{b+1}").Value = "Login page
verified.".colorizegreen)
puts "\nWeb page opened successfully\n".colorizegreen)

Thankx in advance

Set the .Font.ColorIndex value of your range:

$worksheet.Range("c#{b+1}").Font.ColorIndex = 50

More color index values here:

http://www.ozgrid.com/VBA/ReturnCellColor.htm

Hope that helps.

David

http://rubyonwindows.blogspot.com