Top Level Namespace

Defined Under Namespace

Modules: Roo

Instance Method Summary collapse

Instance Method Details

#spreadsheet(spreadsheet, sheets, options = {}) ⇒ Object 



2
3
4
5
6
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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
 
# File 'lib/roo/roo_rails_helper.rb', line 2

def spreadsheet(spreadsheet, sheets, options={})
  @rspreadsheet = spreadsheet
  coordinates = true # default
  o=""
  if options[:coordinates] != nil
    o << ":coordinates uebergeben: #{options[:coordinates]}"
    coordinates = options[:coordinates]
  end
  if options[:bgcolor]
    bgcolor = options[:bgcolor]
  else
    bgcolor = false
  end

  sheets.each { |sheet|
    @rspreadsheet.default_sheet = sheet
    linenumber = @rspreadsheet.first_row(sheet)
    if options[:first_row]
      linenumber += (options[:first_row]-1)
    end
    o << '<table border="0" cellspacing="1" cellpadding="1">'
    if options[:first_row]
      first_row = options[:first_row]
    end
    if options[:last_row]
      last_row = options[:last_row]
    end
    if options[:first_column]
      first_column = options[:first_column]
    end
    if options[:last_column]
      last_column = options[:last_column]
    end
    first_row    = @rspreadsheet.first_row(sheet) unless first_row
    last_row     = @rspreadsheet.last_row(sheet) unless last_row
    first_column = @rspreadsheet.first_column(sheet) unless first_column
    last_column  = @rspreadsheet.last_column(sheet) unless last_column
    if coordinates
      o << "  <tr>"
      o << "  <td>&nbsp;</td>"
      @rspreadsheet.first_column(sheet).upto(@rspreadsheet.last_column(sheet)) {|c|
        if c < first_column or c > last_column
          next
        end
        o << "    <td>"
        o << "      <b>#{Roo::Base.number_to_letter(c)}</b>"
        o << "    </td>"
      }
      o << "</tr>"
    end
    @rspreadsheet.first_row.upto(@rspreadsheet.last_row) do |y|
      if first_row and (y < first_row or y > last_row)
        next
      end
      o << "<tr>"
      if coordinates
        o << "<td><b>#{linenumber.to_s}</b></td>"
      end
      linenumber += 1
      @rspreadsheet.first_column(sheet).upto(@rspreadsheet.last_column(sheet)) do |x|
        if x < first_column or x > last_column
          next
        end
        if bgcolor
          o << "<td bgcolor=\"#{bgcolor}\">"
        else
          o << '<td bgcolor="lightgreen">'
        end
        if @rspreadsheet.cell(y,x).to_s.empty?
          o << "&nbsp;"
        else
          o << "#{@rspreadsheet.cell(y,x)}"
        end
        o << "</td>"
      end
      o << "</tr>"
    end
    o << "</table>"
  } # each sheet
  return o
end