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
on 2012-10-10 09:56
on 2012-10-10 12:26
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>
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
Log in with Google account | Log in with Yahoo account
No account? Register here.