Method: Excelx#formulas

Defined in:
lib/roo/excelx.rb

#formulas(sheet = nil) ⇒ Object

row, col, formula


216
217
218
219
220
221
222
223
224
225
226
# File 'lib/roo/excelx.rb', line 216

def formulas(sheet=nil)
  sheet = @default_sheet unless sheet
  read_cells(sheet) unless @cells_read[sheet]
  if @formula[sheet]
    @formula[sheet].each.collect do |elem|
      [elem[0][0], elem[0][1], elem[1]]
    end
  else
    []
  end
end