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.