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 <firstname.lastname@example.org>
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.