module Roo::Utils
Constants
- LETTERS
Public Class Methods
num_cells_in_range(str)
click to toggle source
Compute upper bound for cells in a given cell range.
# File lib/roo/utils.rb, line 58 def self.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 = split_coordinate(cells[0]) x2, y2 = split_coordinate(cells[1]) (x2 - (x1 - 1)) * (y2 - (y1 - 1)) end
Public Instance Methods
each_element(path, elements) { |XML(outer_xml).root| ... }
click to toggle source
Yield each element of a given type (‘row’, ‘c’, etc.) to caller
# File lib/roo/utils.rb, line 74 def each_element(path, 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 && Array(elements).include?(node.name) yield Nokogiri::XML(node.outer_xml).root if block_given? end end
letter_to_number(letters)
click to toggle source
convert letters like ‘AB’ to a number (‘A’ => 1, ‘B’ => 2, …)
# File lib/roo/utils.rb, line 44 def letter_to_number(letters) result = 0 while letters && letters.length > 0 character = letters[0, 1].upcase num = LETTERS.index(character) fail ArgumentError, "invalid column character '#{letters[0, 1]}'" if num.nil? num += 1 result = result * 26 + num letters = letters[1..-1] end result end
load_xml(path)
click to toggle source
# File lib/roo/utils.rb, line 67 def load_xml(path) ::File.open(path, 'rb') do |file| ::Nokogiri::XML(file) end end
number_to_letter(n)
click to toggle source
convert a number to something like ‘AB’ (1 => ‘A’, 2 => ‘B’, …)
# File lib/roo/utils.rb, line 25 def number_to_letter(n) letters = '' if n > 26 while n % 26 == 0 && n != 0 letters << 'Z' n = ((n - 26) / 26).to_i end while n > 0 num = n % 26 letters = LETTERS[num - 1] + letters n = (n / 26).to_i end else letters = LETTERS[n - 1] end letters end
split_coord(s)
click to toggle source
# File lib/roo/utils.rb, line 14 def split_coord(s) if s =~ /([a-zA-Z]+)([0-9]+)/ letter = Regexp.last_match[1] number = Regexp.last_match[2].to_i else fail ArgumentError end [letter, number] end
split_coordinate(str)
click to toggle source
# File lib/roo/utils.rb, line 5 def split_coordinate(str) letter, number = split_coord(str) x = letter_to_number(letter) y = number [y, x] end
Also aliased as: ref_to_key