Sorry about the multiple posts everybody. My email was acting very
flaky
yesterday. I could blame Outlook, but IÂ?ll just do what I normally do
and
blame Bill Gates directly.
Sigh,
Ken K.
–
Kenneth A. Kousen, Ph.D.
President
Kousen IT, Inc.
http://www.kousenit.com
[email protected]
From: [email protected]
[mailto:[email protected]] On Behalf Of Ken K.
Sent: Thursday, January 19, 2006 5:05 PM
To: [email protected]
Subject: RE: [Rails] Re: Read data from Excel
Interesting. Before I started digging into RoR, I was planning to do
this
project in Java and had looked at the POI library with that in mind.
Now
that thereÂ?s a port to Ruby, maybe itÂ?ll all work out.
Thanks,
Ken
–
Kenneth A. Kousen, Ph.D.
President
Kousen IT, Inc.
http://www.kousenit.com
[email protected]
From: [email protected]
[mailto:[email protected]] On Behalf Of Thibaut
Barrère
Sent: Thursday, January 19, 2006 7:25 AM
To: [email protected]
Subject: Re: [Rails] Re: Read data from Excel
Hi
a bit late maybe, but have a look at this which I just discovered (not
tested yet) : the poi ruby bindings
(POI Ruby Bindings)
===========
The POI library can now be compiled as a Ruby extension, allowing the
API to
be called from Ruby language programs. Ruby users can therefore read and
write OLE2 documents, such as Excel files with ease
The bindings are generated by compiling POI with gcj
http://gcc.gnu.org/java/ , and generating the Ruby wrapper using SWIG
http://www.swig.org/ . The aim is the keep the POI api as-is. However,
where java standard library objects are used, an effort is made to
transform
them smoothly into Ruby objects. Therefore, where the POI API takes an
OutputStream, you can pass an IO object. Where the POI works
java.util.Date
or java.util.Calendar object, you can work with a Ruby Time object.
===========
Thibaut
[blog] http://www.dotnetguru2.org/tbarrere
On 18/01/06, Mischa K. [email protected] wrote:
Ken K. wrote:
A client of mine has a ton of data stored in Excel spreadsheets. I’m
building a web application for her (backed by a real db of course) and
want
to import all that data. Is there a library available to read data from
Excel? Is there an easy way to upload the spreadsheets and then read
the
data?
The easiest way to go about this is using the OLE DB driver in windows
to extract the data trough SQL.
Another way would be windows automation to save the data in the
worksheets / export the files to xml.
Both require a windows platform though.
–
Posted via http://www.ruby-forum.com/.