Module: Rspreadsheet::Tools

Defined in:
lib/rspreadsheet/worksheet.rb

Class Method Summary collapse

Class Method Details

.convert_cell_address(*coords) ⇒ Object

converts cell adress like ‘F12’ to pair od integers [row,col]



8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 
# File 'lib/rspreadsheet/worksheet.rb', line 8

def self.convert_cell_address(*coords)
  if coords.length == 1
    coords.match(/^([A-Z]{1,3})(\d{1,8})$/)
    colname = $~[1]
    rowname = $~[2]
  elsif coords.length == 2
    colname = coords[0]
    rowname = coords[1]
  else
    raise 'Wrong number of arguments'
  end
    
  colname=colname.rjust(3,'@')
  col = (colname[-1].ord-65)+(colname[-2].ord-64)*26+(colname[-3].ord-64)*26*26
  row = rowname.to_i-1
  return [row,col]
end