Module: Roo::Formatters::XML

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

Instance Method Summary collapse

Instance Method Details

#to_xml ⇒ Object 



5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
 
# File 'lib/roo/formatters/xml.rb', line 5

def to_xml
  Nokogiri::XML::Builder.new do |xml|
    xml.spreadsheet do
      sheets.each do |sheet|
        self.default_sheet = sheet
        xml.sheet(name: sheet) do |x|
          if first_row && last_row && first_column && last_column
            # sonst gibt es Fehler bei leeren Blaettern
            first_row.upto(last_row) do |row|
              first_column.upto(last_column) do |col|
                next if empty?(row, col)

                x.cell(cell(row, col),
                row: row,
                column: col,
                type: celltype(row, col))
              end
            end
          end
        end
      end
    end
  end.to_xml
end