Class: RobustExcelOle::AddressTool

Inherits:
Base
  • Object
show all
Defined in:
lib/robust_excel_ole/address_tool.rb

Defined Under Namespace

Classes: AddressAlreadyInRightFormat

Instance Method Summary collapse

Constructor Details

#initialize(address_string) ⇒ AddressTool

Returns a new instance of AddressTool.



7
8
9
10
11
 
# File 'lib/robust_excel_ole/address_tool.rb', line 7

def initialize(address_string)
  r1c1_letters = address_string.gsub(/[0-9]/,'')
  @row_letter = r1c1_letters[0..0]
  @col_letter = r1c1_letters[1..1]
end

Instance Method Details

#as_a1(address) ⇒ Object

transformation from integer-range or r1c1.format to a1-format not implemented



26
27
28
 
# File 'lib/robust_excel_ole/address_tool.rb', line 26

def as_a1(address)
  transform_address(address, :a1)
end

#as_integer_ranges(address) ⇒ Object 



30
31
32
 
# File 'lib/robust_excel_ole/address_tool.rb', line 30

def as_integer_ranges(address)
  transform_address(address, :int_range)
end

#as_r1c1(address) ⇒ Object 



21
22
23
 
# File 'lib/robust_excel_ole/address_tool.rb', line 21

def as_r1c1(address)
  transform_address(address, :r1c1)
end

#s2n(s) ⇒ Object 



109
110
111
 
# File 'lib/robust_excel_ole/address_tool.rb', line 109

def s2n(s)
  s!="" ? (s[0] == "[" ? [s.gsub(/\[|\]/,'').to_i] : (s.to_i!=0 ? s.to_i : s)) : nil
end