← Math

Excel Column Number

Easy
Python
def title_to_number(s):
    result=0
    for c in s:
        result=result*26+(ord(c)-ord('A')+1)
    return result
Java
public int titleToNumber(String s){
    int result=0;
    for(char c:s.toCharArray())
        result=result*26+(c-'A'+1);
    return result;
}

Key Insight

Python ord() vs Java direct char arithmetic c-'A'.

Python → Java Differences

  • ord(c)-ord('A') vs c-'A'
  • Python string iteration vs toCharArray()
  • Base-26 identical
Python
def title_to_number(s):
    result=0
    for c in s:
        result=result*26+(ord(c)-ord('A')+1)
    return result
Java
public int titleToNumber(String s){
    int result=0;
    for(char c:s.toCharArray())
        result=result*26+(c-'A'+1);
    return result;
}

Algorithm Steps

1. Process each char
2. result = result*26 + value
← Previous All Math Next →