From: Fredrik Jagenheim <jagenheim@...>
Date: 2005-06-17T16:45:52+09:00
Subject: Excel scripting

Hi,

Why isn't this working as expected?

require 'win32ole'

data1 = []
100.times { data1 << rand(100) }

excel = WIN32OLE::new('excel.Application')
workbook = excel.Workbooks.Add
worksheet = workbook.Worksheets(1)
worksheet.Select # bring it to front

worksheet.Range('a1:c1')['Value'] = ['Test', '25', 'result']
worksheet.Range('a2:a4')['Value'] = ['Test', '25', 'result']

excel['Visible'] = true



This results in:
Test 25 result
Test
Test
Test

while I expected:
Test 25 result
Test
25
result

Any ideas?

//F