Working with excel files using Ruby

I am new to Ruby. I am working on a code wherein I need to read data
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
know which one/s I should use to get going.
Thanks in advance!


I tried roo and spreadsheet. First one works perfect with Google
Spreadsheet, but has just read ability for Microsoft Excel. Better
is spreadsheet gem.
Look at:

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.