[Ruby] working with excel spreadsheets (.xls) in ruby/rails

[Ali Rizvi]

On a similar note here is poi ruby bindings page with some example code:
http://jakarta.apache.org/poi/poi-ruby.html

and here is rubygarden wiki page on using winole32 for excel files:
http://wiki.rubygarden.org/Ruby/page/show/ScriptingExcel

This looks interesting as I did know of about the Spreadsheet::Excel module
before I saw this:
http://www.bigbold.com/snippets/posts/show/2792

Hope this helps.
Ali


On 1/5/07, Sean Blakey <pythonista at gmail.com> wrote:
>
> In Java, I've used the Jakarta POI to parse Excel files on Windows and
> MacOS (http://jakarta.apache.org/poi/index.html). I'm not aware of any
> Ruby equivalent, but the project does have some useful technical
> references if you are going to try to write such a parser on your own.
>
> I realize that moving from "windows specific" to "relying on Java"
> probably isn't much help, unless you want to play with JRuby.
>
>
> On 1/5/07, Neil Moomey <neil at motznik.com> wrote:
> > Here is an example of working with Excel using WIN32OLE.  CSV might be
> the
> > easiest solution though.
> > http://www.rubycentral.com/book/win32.html
> >
> > Neil
> >
> >
> > > On 1/5/07, shaners becker <veganstraightedge at gmail.com> wrote:
> > > >>
> > > >> i'm building an app that will updates its list of available
> products
> > > >> every month from a file on the distributors website. unfortunately,
> > > >> they don't provide anything remotely resembling an api. the best i
> > > >> can do is import the contents of an Excel spreadsheet.
> > > >>
> > > >> i've looked around a bit and all i'm seeing is:
> > > >> - generating xls files from ruby
> > > >> - manually export a .csv from excel then importing from that
> > > >> - using windows specific ruby libraries
> > > >>
> > > >> before i dig into this and start building it myself, i wanted to
> know
> > > >> if anyone else knows of anything out there that doesn't anything
> like
> > > >> this. basically, just reads the contents of an .xls file and enters
> > > >> them into a table with an identical mapping.
> > > >>
> > > >> any ideas?
> > > >> thanks
> > > >> shane
> > >
> > _______________________________________________
> > Ruby at zenspider.com - Seattle.rb non-commercial list
> > http://www.zenspider.com/seattle.rb
> > http://www.zenspider.com/mailman/listinfo/ruby
> >
>
>
> --
> Sean Blakey
> _______________________________________________
> Ruby at zenspider.com - Seattle.rb non-commercial list
> http://www.zenspider.com/seattle.rb
> http://www.zenspider.com/mailman/listinfo/ruby
>