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

[Sean Blakey]

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