Ruby Excels not

ruby-talk
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).

···

-----Original Message-----
From: Casimir [mailto:pikEISPAMMMseli@welho.com]
Sent: Wednesday, February 06, 2008 7:05 AM
To: ruby-talk ML
Subject: Ruby Excels not

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?

This email and any attached files are confidential and intended solely for the intended recipient(s). If you are not the named recipient you should not read, distribute, copy or alter this email. Any views or opinions expressed in this email are those of the author and do not represent those of the company. Warning: Although precautions have been taken to make sure no viruses are present in this email, the company cannot accept responsibility for any loss or damage that arise from the use of this email or attachments.

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 Danese kirjoitti:

···

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).

-----Original Message-----
From: Casimir [mailto:pikEISPAMMMseli@welho.com] Sent: Wednesday, February 06, 2008 7:05 AM
To: ruby-talk ML
Subject: Ruby Excels not

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?

This email and any attached files are confidential and intended solely for the intended recipient(s). If you are not the named recipient you should not read, distribute, copy or alter this email. Any views or opinions expressed in this email are those of the author and do not represent those of the company. Warning: Although precautions have been taken to make sure no viruses are present in this email, the company cannot accept responsibility for any loss or damage that arise from the use of this email or attachments.