From: "Berger, Daniel" <djberge@...>
Date: 2003-11-18T01:25:19+09:00
Subject: Re: Scrounging for WIN32OLE <--> MS-Excel Examples

> -----Original Message-----
> From: dhtapp [mailto:dhtapp@cox.net] 
> Sent: Sunday, November 16, 2003 6:21 PM
> To: ruby-talk@ruby-lang.org
> Subject: Scrounging for WIN32OLE <--> MS-Excel Examples

> Hi,
> 
> I've suddenly developed an interest in populating an Excel 
> worksheet from within a little simulation I'm running.
> Does anyone know of some docs or guidelines posted somewhere 
> that I may have missed?
<snip>
> 
> Thanks,
> 
> - dan
> 
> PS I know there's a specialized Excel library to write 
> worksheets directly, but that appears to be semi-broken under 
> 1.8, and I'm not nearly experienced enough to know how to 
> patch it yet.

Hi Dan,

Are you referring to my "spreadsheet" package?  Last I checked it worked
fine under 1.8.x, though it's possible I've used deprecated methods
somewhere.  I'll double check this week.

My package isn't broken, but it does have some limitations.  The big two
are a lack of support for formulas, and the inability to create
workbooks over 7 MB.  Also, my package is "write only", so if you need
to read data back out the spreadsheet, you're out of luck.  However,
none of this sounds like an issue in your case.

If you do happen to find any bugs, please submit them to the SourceForge
site at http://rubyspreadsheet.sourceforge.net/.

Regards,

Dan