Method: FlexData::Spreadsheet#aggregate

Defined in:
lib/flex_data/spreadsheet.rb

#aggregate(col1, col2, operator) ⇒ Object 



78
79
80
81
82
83
84
85
86
 
# File 'lib/flex_data/spreadsheet.rb', line 78

def aggregate (col1, col2, operator)
  @sheet.data.inject([]) { |acc, row|
    if row[col1].nil? || row[col2].nil?
      acc
    else
      acc << eval("row[col1] #{operator.to_s} row[col2]")
    end
  }
end