Class: Roo::OpenOffice
Direct Known Subclasses
Constant Summary
Constants inherited from Base
Base::MAX_ROW_COL, Base::MIN_ROW_COL, Base::TEMP_PREFIX
Instance Attribute Summary
Attributes inherited from Base
Instance Method Summary collapse
-
#cell(row, col, sheet = nil) ⇒ Object
Returns the content of a spreadsheet-cell.
-
#celltype(row, col, sheet = nil) ⇒ Object
returns the type of a cell: * :float * :string * :date * :percentage * :formula * :time * :datetime.
-
#comment(row, col, sheet = nil) ⇒ Object
returns the comment at (row/col) nil if there is no comment.
-
#comments(sheet = nil) ⇒ Object
returns each comment in the selected sheet as an array of elements [row, col, comment].
-
#font(row, col, sheet = nil) ⇒ Object
Given a cell, return the cell’s style.
-
#formula(row, col, sheet = nil) ⇒ Object
Returns the formula at (row,col).
-
#formula?(*args) ⇒ Boolean
Predicate methods really should return a boolean value.
-
#formulas(sheet = nil) ⇒ Object
returns each formula in the selected sheet as an array of elements [row, col, formula].
-
#initialize(filename, options = {}) ⇒ OpenOffice
constructor
initialization and opening of a spreadsheet file values for packed: :zip.
-
#label(labelname) ⇒ Object
returns the row,col values of the labelled cell (nil,nil) if label is not defined.
-
#labels(sheet = nil) ⇒ Object
Returns an array which all labels.
- #method_missing(m, *args) ⇒ Object
-
#officeversion ⇒ Object
version of the Roo::OpenOffice document at 2007 this is always “1.0”.
- #sheets ⇒ Object
-
#to_s(sheet = nil) ⇒ Object
shows the internal representation of all cells mainly for debugging purposes.
Methods inherited from Base
#cell_type_by_value, #collect_last_row_col_for_sheet, #column, #default_sheet, #default_sheet=, #each, #each_with_pagename, #empty?, #find, #first_column_as_letter, #first_last_row_col_for_sheet, #info, #inspect, #last_column_as_letter, #parse, #reload, #row, #row_with, #set, #sheet, #to_csv, #to_matrix, #to_xml, #to_yaml
Constructor Details
#initialize(filename, options = {}) ⇒ OpenOffice
initialization and opening of a spreadsheet file values for packed: :zip
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 |
# File 'lib/roo/open_office.rb', line 10 def initialize(filename, ={}) packed = [:packed] file_warning = [:file_warning] || :error @only_visible_sheets = [:only_visible_sheets] file_type_check(filename,'.ods','an Roo::OpenOffice', file_warning, packed) @tmpdir = make_tmpdir(filename.split('/').last, [:tmpdir_root]) @filename = local_filename(filename, @tmpdir, packed) #TODO: @cells_read[:default] = false Zip::File.open(@filename) do |zip_file| if content_entry = zip_file.glob("content.xml").first roo_content_xml_path = File.join(@tmpdir, 'roo_content.xml') content_entry.extract(roo_content_xml_path) decrypt_if_necessary( zip_file, content_entry, roo_content_xml_path, ) else raise ArgumentError, 'file missing required content.xml' end end super(filename, ) @formula = Hash.new @style = Hash.new @style_defaults = Hash.new { |h,k| h[k] = [] } @table_display = Hash.new { |h,k| h[k] = true } @font_style_definitions = Hash.new @comment = Hash.new @comments_read = Hash.new end |
Dynamic Method Handling
This class handles dynamic methods through the method_missing method
#method_missing(m, *args) ⇒ Object
43 44 45 46 47 48 49 50 51 52 53 |
# File 'lib/roo/open_office.rb', line 43 def method_missing(m,*args) read_labels # is method name a label name if @label.has_key?(m.to_s) row,col = label(m.to_s) cell(row,col) else # call super for methods like #a1 super end end |
Instance Method Details
#cell(row, col, sheet = nil) ⇒ Object
Returns the content of a spreadsheet-cell. (1,1) is the upper left corner. (1,1), (1,‘A’), (‘A’,1), (‘a’,1) all refers to the cell at the first line and first row.
59 60 61 62 63 64 65 66 67 68 |
# File 'lib/roo/open_office.rb', line 59 def cell(row, col, sheet=nil) sheet ||= default_sheet read_cells(sheet) row,col = normalize(row,col) if celltype(row,col,sheet) == :date yyyy,mm,dd = @cell[sheet][[row,col]].to_s.split('-') return Date.new(yyyy.to_i,mm.to_i,dd.to_i) end @cell[sheet][[row,col]] end |
#celltype(row, col, sheet = nil) ⇒ Object
returns the type of a cell:
-
:float
-
:string
-
:date
-
:percentage
-
:formula
-
:time
-
:datetime
118 119 120 121 122 123 124 125 126 127 |
# File 'lib/roo/open_office.rb', line 118 def celltype(row,col,sheet=nil) sheet ||= default_sheet read_cells(sheet) row,col = normalize(row,col) if @formula[sheet][[row,col]] return :formula else @cell_type[sheet][[row,col]] end end |
#comment(row, col, sheet = nil) ⇒ Object
returns the comment at (row/col) nil if there is no comment
188 189 190 191 192 193 194 |
# File 'lib/roo/open_office.rb', line 188 def comment(row,col,sheet=nil) sheet ||= default_sheet read_cells(sheet) row,col = normalize(row,col) return nil unless @comment[sheet] @comment[sheet][[row,col]] end |
#comments(sheet = nil) ⇒ Object
returns each comment in the selected sheet as an array of elements
- row, col, comment
198 199 200 201 202 203 204 205 206 207 208 |
# File 'lib/roo/open_office.rb', line 198 def comments(sheet=nil) sheet ||= default_sheet read_comments(sheet) unless @comments_read[sheet] if @comment[sheet] @comment[sheet].each.collect do |elem| [elem[0][0],elem[0][1],elem[1]] end else [] end end |
#font(row, col, sheet = nil) ⇒ Object
Given a cell, return the cell’s style
102 103 104 105 106 107 108 |
# File 'lib/roo/open_office.rb', line 102 def font(row, col, sheet=nil) sheet ||= default_sheet read_cells(sheet) row,col = normalize(row,col) style_name = @style[sheet][[row,col]] || @style_defaults[sheet][col - 1] || 'Default' @font_style_definitions[style_name] end |
#formula(row, col, sheet = nil) ⇒ Object
Returns the formula at (row,col). Returns nil if there is no formula. The method #formula? checks if there is a formula.
73 74 75 76 77 78 |
# File 'lib/roo/open_office.rb', line 73 def formula(row,col,sheet=nil) sheet ||= default_sheet read_cells(sheet) row,col = normalize(row,col) @formula[sheet][[row,col]] end |
#formula?(*args) ⇒ Boolean
Predicate methods really should return a boolean value. Hopefully no one was relying on the fact that this previously returned either nil/formula
83 84 85 |
# File 'lib/roo/open_office.rb', line 83 def formula?(*args) !!formula(*args) end |
#formulas(sheet = nil) ⇒ Object
returns each formula in the selected sheet as an array of elements
- row, col, formula
89 90 91 92 93 94 95 96 97 98 99 |
# File 'lib/roo/open_office.rb', line 89 def formulas(sheet=nil) sheet ||= default_sheet read_cells(sheet) if @formula[sheet] @formula[sheet].each.collect do |elem| [elem[0][0], elem[0][1], elem[1]] end else [] end end |
#label(labelname) ⇒ Object
returns the row,col values of the labelled cell (nil,nil) if label is not defined
159 160 161 162 163 164 165 166 167 168 169 170 171 |
# File 'lib/roo/open_office.rb', line 159 def label(labelname) read_labels unless @label.size > 0 return nil,nil,nil end if @label.has_key? labelname return @label[labelname][1].to_i, ::Roo::Utils.letter_to_number(@label[labelname][2]), @label[labelname][0] else return nil,nil,nil end end |
#labels(sheet = nil) ⇒ Object
Returns an array which all labels. Each element is an array with
- labelname, [row,col,sheetname]
175 176 177 178 179 180 181 182 183 184 |
# File 'lib/roo/open_office.rb', line 175 def labels(sheet=nil) read_labels @label.map do |label| [ label[0], # name [ label[1][1].to_i, # row ::Roo::Utils.letter_to_number(label[1][2]), # column label[1][0], # sheet ] ] end end |
#officeversion ⇒ Object
version of the Roo::OpenOffice document at 2007 this is always “1.0”
144 145 146 147 |
# File 'lib/roo/open_office.rb', line 144 def officeversion oo_version @officeversion end |
#sheets ⇒ Object
129 130 131 132 133 134 135 136 137 138 139 140 |
# File 'lib/roo/open_office.rb', line 129 def sheets unless @table_display.any? doc.xpath("//*[local-name()='automatic-styles']").each do |style| read_table_styles(style) end end doc.xpath("//*[local-name()='table']").map do |sheet| if !@only_visible_sheets || @table_display[attr(sheet,'style-name')] sheet.attributes["name"].value end end.compact end |
#to_s(sheet = nil) ⇒ Object
shows the internal representation of all cells mainly for debugging purposes
151 152 153 154 155 |
# File 'lib/roo/open_office.rb', line 151 def to_s(sheet=nil) sheet ||= default_sheet read_cells(sheet) @cell[sheet].inspect end |