require 'win32ole'
#Open excel application
@@excel = WIN32OLE.new("excel.application")
WIN32OLE.const_load(@@excel)
@@excel.visible = false
#Add worksheet.
@@workbook = @@excel.workbooks.add
@@worksheet = @@workbook.Worksheets(1)
#Define the format of the cell
@@worksheet.range("a1:z200").Interior"ColorIndex" = 2 #Define the interior line color in [a1:z200]
@@worksheet.range("a1:c1")'Value' = "Tests", "#", "%"
#@@worksheet.range("a1:c1").value = "Tests", "#", "%"
@@worksheet....