171. Excel Sheet Column Number

1. Question

Given a string columnTitle that represents the column title as appear in an Excel sheet, return its corresponding column number.

2. Examples

For example:

A -> 1
B -> 2
C -> 3
...
Z -> 26
AA -> 27
AB -> 28 
...

Example 1:

Input: columnTitle = "A"
Output: 1

Example 2:

Input: columnTitle = "AB"
Output: 28

Example 3:

Input: columnTitle = "ZY"
Output: 701

Example 4:

Input: columnTitle = "FXSHRXW"
Output: 2147483647

3. Constraints

1 <= columnTitle.length <= 7
columnTitle consists only of uppercase English letters.
columnTitle is in the range ["A", "FXSHRXW"].

4. References

5. Solutions

class Solution {
    public int titleToNumber(String columnTitle) {
        int res = 0;
        for(int i = 0; i <  columnTitle.length(); i++){
            int tmp = columnTitle.charAt(i) - 'A' + 1;
            res = res * 26 + tmp;
        }
        return res;
    }
}
Copyright © rootwhois.cn 2021-2022 all right reserved,powered by GitbookFile Modify: 2022-11-26 20:03:31

results matching ""

    No results matching ""