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

[shaners becker]

thanks, but i don't think that does me any good.

looks like i'll be going the csv route.

that just means, once a month i have to open an xls file and save it  
as a csv. or write a client side script that automates that for me.  
applescript or automator or something. either way, not quite as DRY  
as i want.

thanks




On Jan 5, 2007, at 6:14 AM, ben wiseley wrote:

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

------------------------------------
first things first. next things next.
http://theresistancearmy.com/blog/
------------------------------------