From: daz <dooby@...10.karoo.co.uk>
Date: 2003-11-17T10:25:57+09:00
Subject: Re: Scrounging for WIN32OLE <--> MS-Excel Examples


"Bernhard Leicher" <bernhard.leicher@t-online.de> wrote:
>
> # this should also be possible
> sheet.cells(4,1).value=7
>

Not my question, Bernhard, but thanks for the reply.

I spent some time looking at the problem (thinking that
it should be fairly simple) and got nowhere.


Now ...
# Multiplication Table without alphanumeric cell references:

require 'win32ole'
excel = WIN32OLE.new("Excel.application")
excel.visible = true
excel.Workbooks.Add()

for row in (1..12)
  for col in (1..12)
    excel.cells(row, col).value = row * col
  end
end


OK, it was easy - with the right help :)


daz