Class: Bmg::Reader::Excel

Inherits:
Object
  • Object
show all
Includes:
Bmg::Reader
Defined in:
lib/bmg/reader/xlsx.rb

Constant Summary collapse

DEFAULT_OPTIONS = 
{
  sheet: 0,
  skip: 0,
  row_num: true
}

Instance Attribute Summary

Attributes included from Bmg::Reader

#type

Instance Method Summary collapse

Methods included from Bmg::Relation

#_count, #bind, #count, #debug, #delete, empty, #empty?, #insert, new, #one, #one_or_nil, #to_csv, #to_json, #to_xlsx, #type, #update, #visit, #with_type, #with_type_attrlist, #with_typecheck, #without_typecheck, #y_by_x, #ys_by_x

Methods included from Algebra

#allbut, #autosummarize, #autowrap, #constants, #extend, #group, #image, #join, #left_join, #matching, #materialize, #minus, #not_matching, #page, #project, #rename, #restrict, #spied, #summarize, #transform, #ungroup, #union, #unspied, #unwrap

Methods included from Algebra::Shortcuts

#cross_product, #exclude, #image, #images, #join, #left_join, #matching, #not_matching, #prefix, #rxmatch, #suffix, #ungroup, #unwrap, #where

Constructor Details

#initialize(type, path, options = {}) ⇒ Excel

Returns a new instance of Excel.



12
13
14
15
16
17
 
# File 'lib/bmg/reader/xlsx.rb', line 12

def initialize(type, path, options = {})
  require 'roo'
  @path = path
  @options = DEFAULT_OPTIONS.merge(options)
  @type = type.knows_attrlist? ? type : type.with_attrlist(infer_attrlist)
end

Instance Method Details

#each ⇒ Object 



19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
 
# File 'lib/bmg/reader/xlsx.rb', line 19

def each
  return to_enum unless block_given?

  headers = type.attrlist
  headers = headers[1..-1] if generate_row_num?
  start_at = @options[:skip] + 2
  end_at = spreadsheet.last_row
  (start_at..end_at).each do |i|
    row = spreadsheet.row(i)
    init = init_tuple(i - start_at + 1)
    tuple = (0...headers.size).each_with_object(init){|i,t|
      t[headers[i]] = row[i]
    }
    yield(tuple)
  end
end

#to_ast ⇒ Object 



36
37
38
 
# File 'lib/bmg/reader/xlsx.rb', line 36

def to_ast
  [ :excel, @path, @options ]
end

#to_s ⇒ Object Also known as: inspect 



40
41
42
 
# File 'lib/bmg/reader/xlsx.rb', line 40

def to_s
  "(excel #{@path})"
end