Topic: Reading Excel spreadsheets in Rails
I have a forthcoming application where users will want to load up columns of data in Excel (rather than XML or CSV) and I'll need to be able to read the column headings and push the data into the database. I don't need to manipulate the data via Excel - all I need is to get it out.
The best idea I can come up so far is to use something to extract the data out of the Excel file into CSV and then process the CSV. Gnumeric could read the Excel file but I know nothing of Gnumeric. Google Spreadsheets could load up the Excel file and then allow me to grab it as CSV but it doesn't (yet) have an API. EditGrid looks like Google Spreadsheets and may even be better but the licence remain to be explored and the API doesn't seem to include a file upload. There is also Spreadsheet-ParseExcel but it only goes up to Excel 2000. The ScriptingExcel page at rubygarden assumes you have Excel running on the server, which I won't!
I can't be the first person to try to do something really simple with Excel in Ruby (I'll use PHP if I have to!) so my googling skills clearly aren't good enough. Could someone point me in the right direction?
Last edited by allen (2006-07-11 09:45:37)