libole2 and ruby

[Ara.T.Howard]

i'm looking at libole2 as a portable method of reading excel files. it seems
this project has been taken over by the gunmeric guys so i expect it'll be
maintained. has anyone out there opted to use this via ruby dl in any way for
some project? any opinions on using this vs. some other method of reading
excel files.

thanks.

ps. for those of you who don't know me on the list : i know alot about *nix
but almost nothing about windoze ;-)

-a
--
===============================================================================
| email :: ara [dot] t [dot] howard [at] noaa [dot] gov
| phone :: 303.497.6469
| My religion is very simple. My religion is kindness.
| --Tenzin Gyatso
===============================================================================

 

[Ara.T.Howard]

i'm looking at libole2 as a portable method of reading excel files. it seems
this project has been taken over by the gunmeric guys so i expect it'll be
maintained. has anyone out there opted to use this via ruby dl in any way
for
some project? any opinions on using this vs. some other method of reading
excel files.

thanks.

ps. for those of you who don't know me on the list : i know alot about *nix
but almost nothing about windoze ;-)

replying to myself: it seems the info i was reading was not correct - the docs
for libole2 seem to indicate that it's solely for interfacing with the
'filesystem in a file' setup in ole files - so sorry if original post was off
base.

cheers.

-a
--
===============================================================================
| email :: ara [dot] t [dot] howard [at] noaa [dot] gov
| phone :: 303.497.6469
| My religion is very simple. My religion is kindness.
| --Tenzin Gyatso
===============================================================================

 

[Shashank Date]

Hi Ara,


For a portable way to do this, you may want to take a look at:

http://rubyspreadsheet.sourceforge.net/

If you want to script for reading Excel files on Windows then Win32ole (s=
tandard lib) is the way
to go.

Thanks,
-- shanko


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around=20
http://mail.yahoo.com=20

 

[Ara.T.Howard]

Hi Ara,



For a portable way to do this, you may want to take a look at:

http://rubyspreadsheet.sourceforge.net/

If you want to script for reading Excel files on Windows then Win32ole (standard lib) is the way
to go.

Thanks,
-- shanko

hey shanko-

it seem that is only a writer - at least i can seem to see any reader
functionality... am i mistaken?

at this point the best i seem to be able to do is

CSV:arse(IO:open("xls2csv #{ path }").read)

at least without writing any code.

cheers.

-a
--
===============================================================================
| email :: ara [dot] t [dot] howard [at] noaa [dot] gov
| phone :: 303.497.6469
| My religion is very simple. My religion is kindness.
| --Tenzin Gyatso
===============================================================================

 

[Julian Leviston]

That's quite interesting - I was looking at outputting excel files.
Does this lib do that as well?

Julian.