From: Daniel Berger <djberg96@...>
Date: 2006-02-20T12:53:30+09:00
Subject: Re: Excel file modification without win32ole

Julius de Bruijn wrote:
> Greetings,
>
> I've been coding some internal tools for my company with Ruby for several
> months and I'd like to distribute some of those tools to other employees too.
> I have one specific tool, which does some calculations and iterations,
> displays the values in a table and saves everything to a specified Excel
> template. The toolkit I've been using is Tk in W2k, Linux and OSX.
>
> The problem is the win32ole class. Handling Excel files through the class is
> very slow, and if I pack my program to an exe file with rubyscript2exe, saving
> .xls files through win32ole halts the whole program. I've been searching some
> better classes for reading and writing Excel files with no success. The
> template I'm using is quite complex with many formulae and vba scripts.
>
> I'm sorry I can't publish any code here, but if somebody could give me some
> good hints for better ways to modify and save .xls even without MS Office, the
> next working week would be much nicer... :)

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

Regards,

Dan