class Extract::Sheet

Public Class Methods

inline(str) click to toggle source
# File lib/extract/sheet.rb, line 87
def inline(str)
  InlineDef.new(:raw => str).sheet
end
load(file,sheet_name=nil) click to toggle source
# File lib/extract/sheet.rb, line 64
def load(file,sheet_name=nil)
  w = Roo::Excelx.new(file)
  w.default_sheet = sheet_name || w.sheets.first

  sheet = Extract::Sheet.new

  ("A".."Z").each do |col|
    (1..100).each do |row|
      cell_text = w.cell(row,col)
      val = if cell_text.present? && w.formula?(row,col)
        "=" + w.formula(row,col).gsub(" ","")
      else
        cell_text
      end
      loaded = w.cell(row,col)
      sheet["#{col}#{row}"] = val if val.present?
      sheet.loaded_values["#{col}#{row}"] = loaded if loaded.present?
    end
  end

  sheet
end

Public Instance Methods

[](c) click to toggle source
# File lib/extract/sheet.rb, line 11
def [](c)
  res = cells[c]
  #puts "doing #{c} #{res}"
  if res.to_s =~ /^=/
    self.cache[c] ||= Extract::Parser.new(:str => res, :sheet => self).excel_value
  else
    res
  end
end
[]=(c,val) click to toggle source
# File lib/extract/sheet.rb, line 8
def []=(c,val)
  self.cells[c] = val
end
clear_cache!() click to toggle source
# File lib/extract/sheet.rb, line 24
def clear_cache!
  self.cache = {}
end
deps(c) click to toggle source
# File lib/extract/sheet.rb, line 32
def deps(c)
  res = cells[c]
  res = if res.to_s =~ /^=/
    d = Extract::Parser.new(:str => res, :sheet => self).deps
    d.map do |dep|
      d2 = deps(dep)
      if d2.empty?
        dep
      else
        d2
      end
    end.flatten
  else
    []
  end
  res.flatten.uniq.map do |c|
    if c =~ /"/
      nil
    else
      c.gsub("$","")
    end
  end.select { |x| x }.sort.uniq
end
each_value_comp() { |k,cells,self,v| ... } click to toggle source
# File lib/extract/sheet.rb, line 56
def each_value_comp
  loaded_values.each do |k,v|
    yield k,cells[k],self[k],v
  end
end
eval(str) click to toggle source
# File lib/extract/sheet.rb, line 28
def eval(str)
  Extract::Parser.new(:str => str, :sheet => self).excel_value
end
raw_value(c) click to toggle source
# File lib/extract/sheet.rb, line 20
def raw_value(c)
  cells[c]
end