From: Leo Razoumov <see_signature@127.0.0.1>
Date: 2001-03-31T10:10:05+09:00
Subject: [ruby-talk:13368] [Q] Win32OLE  documentation and tips??

I tried out a very nice and useful example from the Thomas & Hunt book page 168.
I am using Ruby-1.6.2 on Windows-2000 Professional and everything worked out
just fine!!

This script automatically starts Excel spreadsheet, enters data into the cells,
plots the data in the charts and even provides some animation.
Automatic data entry and plotting is _very_ useful and can be a life saver.

The only problem I have that the BOOK coverage of win32ole is very sketchy and
does not provide any hints on more advanced usage. I tried Visual Basic Editor
included with Excel. It lists some properties (with their names) of few OLE
objects but I could not find out the particular attributes I need.

Where can I learn more on creating automatic scripts for Excel??
Also any Ruby specific hints on the issue are welcome.

I am particularly interested in the following:
  * two dimensional scatter plots with lines and dots
  * setting ranges on X, Y axes (using log scale as an option)
  * specifing chart title
  * specifying labels for individual plots
  * moving legend to the bottom center position


Thanks,
--Leo [ slonika AT yahoo DOT com ]