Hello, 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: http://raa.ruby-lang.org/project/parseexcel/ http://rubyforge.org/projects/spreadsheet/ http://rubyforge.org/projects/roo/ 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 Regards --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
