Method: XLSX::Cell.cell_name

Defined in:
lib/xlsx/cell.rb

.cell_name(row_number, col_number) ⇒ Object 



40
41
42
43
44
45
46
47
48
49
50
51
52
 
# File 'lib/xlsx/cell.rb', line 40

def self.cell_name(row_number, col_number)
  raise "Column #{col_number} out of range" if col_number > 701
  
  if col_number <= 25
    col_name = ''
  else
    c = col_number / 26
    col_name = (?A.ord + c - 1).chr
    col_number = col_number % 26
  end
  col_name += (?A.ord + col_number).chr
  "#{col_name}#{row_number + 1}"
end