Ruby Excels not

Ruby
1

Ok so I wanna play with some spreadsheets. Lets see. Lets copypaste from
the pickaxe.

require ‘win32ole’

Creates OLE object to Excel

excel = WIN32OLE.new(“excel.application”)

#and so on…

Ruby replies:
myExcelApp.rb:9:in initialize': unknown OLE server:Excel.Application’
(WIN32OLERuntimeError)
HRESULT error code:0x800401f3
Invalid class string from myExcelApp.rb:9:in `new’
from rudumapponator.rb:9

Ie. no joy. Something wrong with the Win32Ole library?

2

Your code works fine for me on irb on win xp.

Can you actually open a ‘genuine’ xls file on your machine to see if
ms-excel/office is working properly? I’ve had problems before where
win32ole wouldn’t work b/c the ms-office software license had not yet
been activated (don’t remember what the specific error was, tho).

3

Ah! slap forehead So I need a excel license installed on the machine??

That would explain the problem. Silly me! I guess I will need to turn to
Open Office…

Paul D. kirjoitti: