|
[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
[NMLUG] Ruby
I don't think I could explain how to use the ole functions in Ruby
better than a few searches on google could. But I will try. Any
application that has VBA extentions is capable of being used by Ruby.
I used to use a VC++ program that allowed you to see all the public
methods in a dll or ocx. Now, I generally search the web for an
example in either Ruby or vbs. "Lazy A** programming style"
Converting the found example to my needs is very quick.
---------- Forwarded message ----------
From: Aaron NMLUG-EV <aaron@boim.com>
Date: Aug 15, 2005 7:00 AM
Subject: Re: [NMLUG] Ruby
To: New Mexico Linux Users Group Mail List <nmlug@nmlug.org>
On Sat, 2005-08-13 at 13:49, w robbi wrote:
> I've been using Ruby as a Swiss army knife to help at workfor 8 years
> now. I found I needed a tool to assist me with pulling data out of
> thousands of excel documents and formulate them and push the data to a
> access / MSSQL database. I took a look at VBS and after the "I love
> you" virus and several patches later emailing and other sections of
> vbs changed. This is the #1 thing I hate about windows. I found that
> Ruby would easily load win32ole objects and I could pull all the data
> from the excel documents into hash tables and push it to access
> quickly. Inventory control for the NMCI still uses the ruby program.
> Handing over the program to someone else was cake because of how
> readable the language is to any one who has a little programming
> skill. I've been handed several perl and 2 python programs and they
> were a real *itch to figure out and upgrade when needed.
I'm embarrassed to admit that I've been using some ActiveX stuff at
work. I need to automate the generation of some PowerPoint (PPT)
reports.
I tried VBS for a bit, but it was easier for me to use MatLab's
ActiveX stuff, since the main work is in MatLab anyway.
We just need automatic reports generated in (PPT) as the
MatLab batch job runs.
This talk about win32ole objects interests me.
Are there ActiveX front ends on some other cross-platform
scripting languages, like Perl or Ruby?
Do any of the more Un*X-like or Mat-like major office apps
(Apple's office suite, OpenOffice, or things like Abiword/gnumeric)
have ActiveX-like interfaces to drive them from a script?
_______________________________________________
NMLUG mailing list
NMLUG@nmlug.org
http://www.nmlug.org/mailman/listinfo/nmlug
|
|
