Class: Applocale::ParseXLSXModule::Helper

Inherits:
Object
  • Object
show all
Defined in:
lib/applocale/Core/ParseXLSX/parse_xlsx_module.rb

Class Method Summary collapse

Class Method Details

.collabel_to_colno(collabel) ⇒ Object 



8
9
10
11
12
13
14
15
 
# File 'lib/applocale/Core/ParseXLSX/parse_xlsx_module.rb', line 8

def self.collabel_to_colno(collabel)
  if collabel.match(/^(\d)+$/)
    return collabel.to_i
  end
  number = collabel.tr("A-Z", "1-9a-q").to_i(27)
  number -= 1 if number > 27
  return number
end