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.

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