From: Ryan Westerberg <phoenix_016@...>
Date: 2009-07-09T04:45:27+09:00
Subject: Using ruby to open an Excel file on a mac

Hello everyone,

I have a bit of an issue that I'm trying to work through pertaining to
opening an excel file I want to open using ruby.  I tried looking in
google and all sorts of places but all I could really find is how to
open a new file of Excel.  This I can do no problem, however I am unable
to open an existing file.


I am currently using:

Mac OS X v 10.4.11 PowerPC G4.
Ruby v1.8.6
Rubygems v1.3.4


On the mac my beginning code looks like this

#!/usr/local/bin/env ruby

require 'rubygems'
require 'appscript'


#This script retrieves the data from excel and puts it into arrays
class Test_arraydata

def EXTCOdata(*arrays listed here, removed for security purposes)
  begin

  #opens excel
  $excel=Appscript.app('Microsoft Excel')
  workbook=$excel.activate('\Automation\Safari\<Data location>')

If anyone could help me out with this, it would be greatly appreciated.

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