Method: Roo::Excelx#formulas

Defined in:
lib/roo/excelx.rb

#formulas(sheet = nil) ⇒ Object

returns each formula in the selected sheet as an array of tuples in following format

[row, col, formula], [row, col, formula],…


176
177
178
179
180
 
# File 'lib/roo/excelx.rb', line 176

def formulas(sheet = nil)
  sheet_for(sheet).cells.select { |_, cell| cell.formula }.map do |(x, y), cell|
    [x, y, cell.formula]
  end
end