Forum: Ruby Working with excel files using Ruby

Posted by aakash bambal (Guest)
on 2012-10-10 09:56
(Received via mailing list)
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
Posted by "Иван Бишевац" <ivan.bisevac@gmail.com> (Guest)
on 2012-10-10 12:26
(Received via mailing list)
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 <skyaltitude@gmail.com>
Posted by Joel Pearson (virtuoso)
on 2012-10-10 13:03
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.
Please log in before posting. Registration is free and takes only a minute.
Existing account (Switch to SSL-encrypted connection)
NEW: Do you have a Google/GoogleMail or Yahoo account? No registration required!
Log in with Google account | Log in with Yahoo account
No account? Register here.