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?
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
···
-----Original Message-----