Working with excel files using Ruby

Hi
I am new to Ruby. I am working on a code wherein I need to read data
from
excel, sort on a particular column, write data into the excel etc.
I came across win32ole, roo, parseexcel etc. on the web for this. Need
to
know which one/s I should use to get going.
Thanks in advance!

~Akash

I tried roo and spreadsheet. First one works perfect with Google
Spreadsheet, but has just read ability for Microsoft Excel. Better
solution
is spreadsheet gem.
Look at:
http://stackoverflow.com/a/7429049/507018

2012/10/10 aakash bambal [email protected]

If I want to quickly read an “xls” file I’ll use spreadsheet. If I want
advanced interaction or “xlsx” I’ll use win32ole and the excel object.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs