From: Terje Tjervaag <flecktone@...>
Date: 2005-10-28T18:55:23+09:00
Subject: Re: Oldest Ruby hacker?

On 10/27/05, Charles Roper <charles.roper@gmail.com> wrote:
> The Scripting Excel page on the Garden
> has been invaluable for this, but I'm finding reading in values from
> cells and writing them back again to be extremely slow. Once in a Ruby
> array they process like lightening. Has anyone got any tips for
> speeding up the parsing of ranges, and writing them back again?

Charles,

It's a simple trick but in case you don't know about it, turn off
screen updating while you're doing your routine using:
excel.screenupdating = false
..where excel is your reference to the application (e.g.
WIN32OLE::new('excel/application'))

Remember to turn it back on with '= true' when you're done or excel
won't show your changes.

--
Terje