From: pimeys@...
Date: 2006-02-20T13:43:35+09:00
Subject: Re: Excel file modification without win32ole

> See http://raa.ruby-lang.org/project/spreadsheet/ if you don't mind
> that it uses the Excel 95 format.

That's the module I've been trying to use in my program instead of
win32ole class. The problem is that the spreadsheet class doesn't
support opening an Excel template, it only creates a new file. My
current Excel template is quite complex with seven worksheets, hundreds
of formulae and several hundred lines of VBA, so creating it from
scratch with Ruby's spreadsheet module is out of question.

The problem with win32ole was it's halt when using a compiled
rubyscript2exe version of the program. With small tweaking, I made it
to work. I was using "require 'win32ole'" in a method rather than
loading it in the beginning of the file, which was not very smart move.
The slowness of ole commands and the requirement of Excel still bugs
me, but maybe I can live with it for now.