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

[ben wiseley]

Shane,

I had to do this recently for a project and went the CSV route. I found this
link http://books.evc-cit.info/odf_utils/ruby_to_xhtml.html which looks like
it's trying to convert to Open Document format (which is supported by Office
7)

Let me know if you find something better (that's easy)  :)

-ben


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
>
> ------------------------------------
> first things first. next things next.
> http://theresistancearmy.com/blog/
> ------------------------------------
>
>
>
> _______________________________________________
> Ruby at zenspider.com - Seattle.rb non-commercial list
> http://www.zenspider.com/seattle.rb
> http://www.zenspider.com/mailman/listinfo/ruby
>