module Oxcelix::Cellhelper

The Cellhelper module defines some methods useful to manipulate Cell objects

Public Instance Methods

x(coord=nil) click to toggle source

When called without parameters, returns the x coordinate of the calling cell object based on the value of #@xlcoords If a parameter is given, x will return the x coordinate corresponding to the parameter @example find x coordinate (column number) of a cell

c = Cell.new
c.xlcoords = ('B3')
c.x #=> 1

@param [String] coord Optional parameter used when method is not called from a Cell object @return [Integer] x coordinate

# File lib/oxcelix/cellhelper.rb, line 27
def x(coord=nil)
  if coord.nil?
    coord = @xlcoords
  end
  ('A'..(coord.scan(/\p{Alpha}+|\p{Digit}+/u)[0])).to_a.length-1
end
y(coord=nil) click to toggle source

When called without parameters, returns the y coordinate of the calling cell object based on the value of #@xlcoords If a parameter is given, y will return the y coordinate corresponding to the parameter @example find y coordinate (row number) of a cell

c = Cell.new
c.xlcoords = ('B3')
c.y #=> 2

@param [String] coord Optional parameter used when method is not called from a Cell object @return [Integer] x coordinate

# File lib/oxcelix/cellhelper.rb, line 42
def y(coord=nil)
  if coord.nil?
    coord = @xlcoords
  end
  coord.scan(/\p{Alpha}+|\p{Digit}+/u)[1].to_i-1
end