[Rails] Re: Read data from Excel

[Thibaut Barrère]

Hi

a bit late maybe, but have a look at this which I just discovered (not
tested yet) : the poi ruby bindings (
http://jakarta.apache.org/poi/poi-ruby.html)

===========

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 Kroon <mischa.kroon at gmail.com> wrote:
>
> Ken Kousen 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/.
> _______________________________________________
> Rails mailing list
> Rails at lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060119/a18e9871/attachment.html