Libole2 and ruby

ruby-talk
1

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 :wink:

-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

===============================================================================

2

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

···

On Thu, 4 Aug 2005, Ara.T.Howard wrote:

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 :wink:

--

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

===============================================================================

3

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

Julian.

···

On 04/08/2005, at 10:53 AM, Ara.T.Howard wrote:

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 :wink:

-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

4

Hi Ara,

···

--- "Ara.T.Howard" <Ara.T.Howard@noaa.gov> wrote:

> i'm looking at libole2 as a portable method of reading excel files.

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

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around

5

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::parse(IO::popen("xls2csv #{ path }").read)

at least without writing any code.

cheers.

-a

···

On Thu, 4 Aug 2005, Shashank Date wrote:

Hi Ara,

--- "Ara.T.Howard" <Ara.T.Howard@noaa.gov> wrote:

i'm looking at libole2 as a portable method of reading excel files.

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

--

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

===============================================================================