Read from Xls File

read-from-xls.rb

require 'roo'

path = '/workspace/data/import.xls'

file_type = `file -b --mime-type #{path}`.strip

xls =
  case file_type
    when 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'application/xml', 'application/vnd.ms-office'
      Roo::Spreadsheet.open(path)
    else
      nil
  end
  
xls.sheets.each { |sheet|
  read_from_row = lambda { |row| 
    puts "sheet: #{sheet}"
    puts row
  } 

  xls.sheet(sheet).each_with_index { |row, idx|
    if idx == 1
    end

    read_from_row.call(row)
  }
}