I’m running into a project where a client has large Excel files
(60.000+ records per file) and he needs an application to import them
into a database to use this data for useful operations (reporting,
calculations … etc).
I know about the available libraries:
I’ve used parseexcel before but for small files. The point is that
parseexcel and spreadhsheet libraries have a reputation that they
can’t handle large excel files (I don’t know about ‘roo’).
The guy here (http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-
talk/223230) created some kind of a bridge between Ruby and Java to
use ‘JavaExcelAPI’ and it did work fine for him!
Has anyone tried importing large excel files with ruby? Do I really
need to use a Java library through a bridge to get my job done?
Personally I prefer to hire a Java developer to do that Excel
importing module than doing a bridge and correct me if I’m wrong.
What do you suggest guys? Is there some great ruby library to do the
job that I never heard of before? Or do you suggest some tweaks like
parsing the Excel file using ‘parseexcel’ like 500 records or
something at a time?
I’m kinda lost and I need your help