From: "Jethrow .." <jethrow@...>
Date: 2010-10-17T17:08:58+09:00
Subject: Re: Excel and Ruby

First off, I'd recommend finding some VB examples for reference (the
Excel Macro recorders will help). Then, once you get a feel for the
Excel Object Model, scripting Excel is easy. Here's a simple example:

    require "WIN32OLE"
    xl = WIN32OLE.new("Excel.Application")
    xl.visible = true
    xl.workbooks.add
    for cell in xl.range("A1:E10")
      cell.value = rand(100)
    end
    xl.range("C3").select
    puts xl.range("C3").value
    gets

This should help too: http://msdn.microsoft.com/en-us/library/aa213696
- jethrow

-- 
Posted via http://www.ruby-forum.com/.