Module: Roo::Utils
Constant Summary collapse
- LETTERS =
('A'..'Z').to_a
Instance Method Summary collapse
-
#each_element(path, elements) ⇒ Object
Yield each element of a given type (‘row’, ‘c’, etc.) to caller.
- #extract_coordinate(s) ⇒ Object (also: #ref_to_key)
- #letter_to_number(letters) ⇒ Object
- #load_xml(path) ⇒ Object
-
#num_cells_in_range(str) ⇒ Object
Compute upper bound for cells in a given cell range.
-
#number_to_letter(num) ⇒ Object
convert a number to something like ‘AB’ (1 => ‘A’, 2 => ‘B’, …).
- #split_coord(str) ⇒ Object
- #split_coordinate(str) ⇒ Object
Instance Method Details
#each_element(path, elements) ⇒ Object
Yield each element of a given type (‘row’, ‘c’, etc.) to caller
83 84 85 86 87 88 89 |
# File 'lib/roo/utils.rb', line 83 def each_element(path, elements) elements = Array(elements) Nokogiri::XML::Reader(::File.open(path, 'rb'), nil, nil, Nokogiri::XML::ParseOptions::NOBLANKS).each do |node| next unless node.node_type == Nokogiri::XML::Reader::TYPE_ELEMENT && elements.include?(node.name) yield Nokogiri::XML(node.outer_xml).root if block_given? end end |
#extract_coordinate(s) ⇒ Object Also known as: ref_to_key
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
# File 'lib/roo/utils.rb', line 7 def extract_coordinate(s) num = letter_num = 0 num_only = false s.each_byte do |b| if !num_only && (index = char_index(b)) letter_num *= 26 letter_num += index elsif index = num_index(b) num_only = true num *= 10 num += index else fail ArgumentError end end fail ArgumentError if letter_num == 0 || !num_only Excelx::Coordinate.new(num, letter_num) end |
#letter_to_number(letters) ⇒ Object
54 55 56 57 58 59 60 61 62 63 64 |
# File 'lib/roo/utils.rb', line 54 def letter_to_number(letters) @letter_to_number ||= {} @letter_to_number[letters] ||= begin result = 0 # :bytes method returns an enumerator in 1.9.3 and an array in 2.0+ letters.bytes.to_a.map{|b| b > 96 ? b - 96 : b - 64 }.reverse.each_with_index{ |num, i| result += num * 26 ** i } result end end |
#load_xml(path) ⇒ Object
76 77 78 79 80 |
# File 'lib/roo/utils.rb', line 76 def load_xml(path) ::File.open(path, 'rb') do |file| ::Nokogiri::XML(file) end end |
#num_cells_in_range(str) ⇒ Object
Compute upper bound for cells in a given cell range.
67 68 69 70 71 72 73 74 |
# File 'lib/roo/utils.rb', line 67 def num_cells_in_range(str) cells = str.split(':') return 1 if cells.count == 1 raise ArgumentError.new("invalid range string: #{str}. Supported range format 'A1:B2'") if cells.count != 2 x1, y1 = extract_coordinate(cells[0]) x2, y2 = extract_coordinate(cells[1]) (x2 - (x1 - 1)) * (y2 - (y1 - 1)) end |
#number_to_letter(num) ⇒ Object
convert a number to something like ‘AB’ (1 => ‘A’, 2 => ‘B’, …)
43 44 45 46 47 48 49 50 51 52 |
# File 'lib/roo/utils.rb', line 43 def number_to_letter(num) result = "" until num.zero? num, index = (num - 1).divmod(26) result.prepend(LETTERS[index]) end result end |
#split_coord(str) ⇒ Object
37 38 39 40 |
# File 'lib/roo/utils.rb', line 37 def split_coord(str) coord = extract_coordinate(str) [number_to_letter(coord.column), coord.row] end |
#split_coordinate(str) ⇒ Object
30 31 32 33 |
# File 'lib/roo/utils.rb', line 30 def split_coordinate(str) warn "[DEPRECATION] `Roo::Utils.split_coordinate` is deprecated. Please use `Roo::Utils.extract_coordinate` instead." extract_coordinate(str) end |