From: "greg.rb" <ghalsey@...>
Date: 2006-07-07T00:24:10+09:00
Subject: Re: excel

Make sure it works when you run Excel. If the addins are properly
installed you are good to go. (Tools/Add-ins...)

require 'win32ole'

xlApp=WIN32OLE::new('Excel.Application')
xlApp.Visible=1
xl_file = ('c:\\Book2.xls')
xlApp.Workbooks.Open(xl_file)


	puts xlApp.Cells(1,1).Formula
	puts xlApp.Cells(1,1).Value

xlApp.ActiveWorkbook.Close()
xlApp.Quit

Produces:
>ruby Excel_hex2dec.rb
=HEX2DEC(255)
597.0
>Exit code: 0