Module: Roo::Formatters::YAML

Included in:
Base
Defined in:
lib/roo/formatters/yaml.rb

Instance Method Summary collapse

Instance Method Details

#to_yaml(prefix = {}, from_row = nil, from_column = nil, to_row = nil, to_column = nil, sheet = default_sheet) ⇒ Object

returns a rectangular area (default: all cells) as yaml-output you can add additional attributes with the prefix parameter like: oo.to_yaml(“sheet” => “1”)



7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
 
# File 'lib/roo/formatters/yaml.rb', line 7

def to_yaml(prefix = {}, from_row = nil, from_column = nil, to_row = nil, to_column = nil, sheet = default_sheet)
  # return an empty string if there is no first_row, i.e. the sheet is empty
  return "" unless first_row

  from_row ||= first_row(sheet)
  to_row ||= last_row(sheet)
  from_column ||= first_column(sheet)
  to_column ||= last_column(sheet)

  result = "--- \n"
  from_row.upto(to_row) do |row|
    from_column.upto(to_column) do |col|
      next if empty?(row, col, sheet)

      result << "cell_#{row}_#{col}: \n"
      prefix.each do|k, v|
        result << "  #{k}: #{v} \n"
      end
      result << "  row: #{row} \n"
      result << "  col: #{col} \n"
      result << "  celltype: #{celltype(row, col, sheet)} \n"
      value = cell(row, col, sheet)
      if celltype(row, col, sheet) == :time
        value = integer_to_timestring(value)
      end
      result << "  value: #{value} \n"
    end
  end

  result
end