Rails - Oct 2013 - Best way to approach reading and parsing a large XLSX file??

Hello, I''m developing an app that basically, receives a 10MB or less
XLSX
files with +30000 rows or so, and another XLSX file with about 200rows, I 
have to read one row of the smallest file, look it up on the largest file 
and write data from both files to a new one. 

I just did a test reading all the rows from the largest file using ROO 
(Spreadsheet doesn''t support XSLX and Creek look good but I
can''t find a
way to read row by row) and write it to a XLS file (no comparisons or 
anything) and it basically made my computer crash, the server crashed, I 
tried rebooting it and it said It was already started, anyway, it was a 
disaster.

So, my question was, is there gem that works best with large XLSX files or 
is there another way to approach this withouth crashing my computer?

This is what I had (It''s very possible I''m doing it wrong,
help is welcome)
*What i was trying to do here, was to process the files and create the new 
XLS file after both of the XLSX files were uploaded:*


require ''roo''
require ''spreadsheet''
class UploadFiles < ActiveRecord::Base
  after_commit :process_files
  attr_accessible :inventory, :material_list
  has_one :inventory
  has_one :material_list
  has_attached_file :inventory, :url=>"/:current_user/inventory", 
:path=>":rails_root/tmp/users/uploaded_files/inventory/inventory.:extension"
  has_attached_file :material_list,
:url=>"/:current_user/material_list",
:path=>":rails_root/tmp/users/uploaded_files/material_list/material_list.:extension"
  validates_attachment_presence :material_list
  accepts_nested_attributes_for :material_list, :allow_destroy => true  
  accepts_nested_attributes_for :inventory, :allow_destroy => true  
  validates_attachment_content_type :inventory, :content_type => 
["application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"],
:message => "Only .XSLX files are accepted as Inventory"
  validates_attachment_content_type :material_list, :content_type => 
["application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"],
:message => "Only .XSLX files are accepted as Material List"
  
  
 def process_files
    inventory =  Roo::Excelx.new(Rails.root.to_s + 
"/tmp/users/uploaded_files/inventory/inventory.xlsx")
    material_list = Roo::Excelx.new(Rails.root.to_s + 
"/tmp/users/uploaded_files/material_list/material_list.xlsx")
    inventory.default_sheet = inventory.sheets.first
    scl = Spreadsheet::Workbook.new
    sheet1 = scl.create_worksheet
    sheet1.row(1).concat %w{ProjectCode ProjectName ContractNo Item Qty 
ItemDescription}
    2.upto(5) do |line|
      @projectCode = inventory.cell(line,''B'')
      @ProjectName = inventory.cell(line,''C'')
      @ContractNo = inventory.cell(line,''D'')
      @Item = inventory.cell(line,''N'')
      @AviQty = inventory.cell(line,''Q'')
      @ItemDescription = inventory.cell(line,''AA'')
      sheet1.row(line).push(@projectCode, @ProjectName, @ContractNo, @Item, 
@AviQty, @ItemDescription)
    end
    scl.write(Rails.root.to_s + 
"/tmp/users/generated/siteconfigurationlist.xls")
  end
end

And it works, but only for small files. If i upload the real files and not 
the test ones, the browser stays "Waiting for localhost" the server
console
doesn''t show any errors, and the output file doesn''t seem to
save at all.
The output is never created. 

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit
https://groups.google.com/d/msgid/rubyonrails-talk/af3ce8c9-d97d-4def-b3bf-d7b017167104%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.