Roo gem performance problems

Rails
1

I am getting unacceptable performace problems by using the roo gem for
reading a file by using XLSX or XLS library from this gem.

Someone may suggest me an alternative about how to parse an .XLSX file?

parsed_file = Excel.new(filename,false, :ignore) if (file_format.upcase == "XLS") parsed_file = Excelx.new(filename,false, :ignore) if (file_format.upcase == "XLSX") raise t "#{filename} is not an Excel file!" if (!parsed_file) 
  parsed_file.default_sheet =

parsed_file.sheets[0]#‘Sheet2’#oo.sheets[1]

  first_row = parsed_file.first_row
  last_row = parsed_file.last_row
  first_column = parsed_file.first_column
  last_column = parsed_file.last_column
  #logger.info "#### Total Rows:#{last_row}, first_row:#{first_row},

last_row:#{last_row}, first_column:#{first_column},
last_column:#{last_column}"

  first_row.upto(last_row) do |current_line|
          # Stuff ....
  end

Thanks

2

More details