D=C5=88a Utorok 07 Febru=C3=A1r 2006 02:36 Paatsch, Bernd nap=C3=ADsal:
Hello,
Is it possible to access Excel spreadsheets through ruby?
If so is there somewhere a code example I can have a look at?
Thanks,
Bernd
If the machine in question is a Windows box with Excel already installed, y=
our=20
best bet is probably using Win32OLE and accessing an Excel interface via CO=
M.=20
Best look at Win32OLE, and Windows / Excel automation docs.
http://www.rubygarden.org/ruby?ScriptingExcel looks like good introductory=
=20
sample code too.
If not, I can only recall a writer package that worked with the binary form=
at,=20
and I had mixed success getting it run on and off Cygwin. There might be=20
something out there that will let you read the zipped XML format out there,=
=20
but I can't recall anything off the top of my head, nor see something that=
=20
flicks a lightbulb on in the first screen of googlage results.
You might feel particularly adventurous and try compiling the POI ruby=20
bindings, if the thought of working with with GCC compiled Java doesn't sca=
re=20
you. (It does indeed scare me...)
That said, the topic is also fairly recurrent on the list in my opinion, so=
=20
give searching the ML archives a try too.
David Vallner