import from excel, data store in database

rubyonrails-talk
1

Hi, Im tryng to import data from excel sheet and storing data into database.

But geeting problem. I hv followed this link : http://spreadsheet.rubyforge.org/

Error occurs

  " OLE2 signature is invalid"

If any one having solution then plz let me know.

2

This is just a shot in the dark. Are you trying to import from Excel 2007 (.xlsx)? I've had problems with other applications reading that format. I resolved it by saving the file as Excel 2003 (.xls) and it worked.