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