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.".colorize(:green)
puts "\nWeb page opened successfully\n".colorize(:green)
Thankx in advance 
--
Posted via http://www.ruby-forum.com/.
Pranjal Jain wrote:
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.".colorize(:green)
puts "\nWeb page opened successfully\n".colorize(:green)Thankx in advance
Set the .Font.ColorIndex value of your range:
$worksheet.Range("c#{b+1}").Font.ColorIndex = 50
More color index values here:
Return Excel Color Index Number or Color as Text. Excel VBA Custom Formula
Hope that helps.
David
--
Posted via http://www.ruby-forum.com/\.
