Top Level Namespace
Defined Under Namespace
Modules: ExcelFontExtensions, Roo, Spreadsheet Classes: Excel, Excel2003XML, Excelx, GenericSpreadsheet, Google, GoogleHTTPError, GoogleReadError, GoogleWriteError, Openoffice, String
Constant Summary collapse
- CHARGUESS =
require ‘parseexcel’
begin require 'charguess' true rescue LoadError => e false end
Instance Method Summary collapse
Instance Method Details
#spreadsheet(spreadsheet, sheets, options = {}) ⇒ Object
1 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 |
# File 'lib/roo/roo_rails_helper.rb', line 1 def spreadsheet(spreadsheet, sheets, ={}) @rspreadsheet = spreadsheet coordinates = true # default o="" if [:coordinates] != nil o << ":coordinates uebergeben: #{[:coordinates]}" coordinates = [:coordinates] end if [:bgcolor] bgcolor = [:bgcolor] else bgcolor = false end sheets.each { |sheet| @rspreadsheet.default_sheet = sheet linenumber = @rspreadsheet.first_row(sheet) if [:first_row] linenumber += ([:first_row]-1) end o << '<table border="0" cellspacing="1" cellpadding="1">' if [:first_row] first_row = [:first_row] end if [:last_row] last_row = [:last_row] end if [:first_column] first_column = [:first_column] end if [:last_column] last_column = [: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> </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>#{GenericSpreadsheet.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 << " " else o << "#{@rspreadsheet.cell(y,x)}" end o << "</td>" end o << "</tr>" end o << "</table>" } # each sheet return o end |