help.rb

require 'rubyXL'

class Kincom

def initialize(file, name)
  @filename = find_filename(file)
  @subject = name
  xlsx_sheets = load(file) #Returnerer object med sheets
  create_data_hash(xlsx_sheets) #Returnerer object (hash) med hvert spark og dets rådata
end

  def load(file)
    book = RubyXL::Parser.parse(file)
    return book.worksheets
  end

  def create_data_hash(sheets)
    array = extract_values(sheets)
    array.each do |a|
      if a.max > 0
        puts "Higher than 0"
      elsif a.max < 0
        puts "Less than 0"
      else
        puts "Error."
      end
    end
  end

  def extract_values(sheets)
    #Måske raise en exception, i stedet for at returne []?
    array = Array.new
    sheets.each do |sheet|
      array << sheet.map do |row|
        row[1].value
        # ? row.cells.map { |cell| cell.value if cell } : []
      end
    end
    return array
  end

  def find_filename(file)
    File.basename(file)
  end

end
puts "tester.."
Kincom.new("test.xlsx", "Lol")