Does anyone have experience or even any ideas of how to read large (80,000+ rows and approx. 14MB) MS Excel files into a Rails app? I have successfully used CSV to read large amounts of data, but can't seem to find a way to use the Excel format. I have looked into the Ruby spreadsheet gem, but according to the documentation it is only for producing Excel files.
Any help would be appreciated.
I would suggest using the parseexcel library. If you have the Ruby
Cookbook it is described in there
That might work... I've tried that on relatively simple excel documents (first column = names, 4 optional columns with integer values) and while it worked for me, it didn't for others. It was character set issues that seemed to come from the machine the excel document was generated on.
Anyway, maybe you won't have that problem, maybe you will. We ended up making our staff convert to CSV first.