From: Dominic Sisneros <dsisnero@...>
Date: 2006-02-22T15:52:18+09:00
Subject: Re: Excel file modification without win32ole

------=_Part_9802_5002758.1140591122301
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

See Spreadsheet::ParseExcel  http://download.ywesee.com/parseexcel

http://download.ywesee.com/parseexcel

Spreadsheet::ParseExcel - Get information from an Excel file.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Version: 0.4.0
Date: 2006-02-16

Short Description:
Spreadsheet::ParseExcel allows you to get information out of a
simple Excel file
This Package is an - as of today incomplete - translation of
Kawai Takanoris Perl-Module.


Requirements
------------

* ruby 1.8

Install
-------

De-Compress archive and enter its top directory.
Then type:

$ ruby setup.rb config
$ ruby setup.rb setup
($ su)
# ruby setup.rb install

You can also install files into your favorite directory
by supplying setup.rb some options. Try "ruby setup.rb --help".


Usage
-----
workbook =3D Spreadsheet::ParseExcel.parse(path_to_file)
worksheet =3D workbook.worksheet(0)
worksheet.each(1) { |row|
puts row.at(0)
}


On 2/19/06, Julius de Bruijn <pimeys@kobaia.net> 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... :)
>
>

------=_Part_9802_5002758.1140591122301--