0171. Excel Sheet Column Number
https://leetcode.com/problems/excel-sheet-column-number
Description
Given a string columnTitle that represents the column title as appear in an Excel sheet, return its corresponding column number.
For example:
A -> 1
B -> 2
C -> 3
...
Z -> 26
AA -> 27
AB -> 28
...Example 1:
**Input:** columnTitle = "A"
**Output:** 1Example 2:
**Input:** columnTitle = "AB"
**Output:** 28Example 3:
**Input:** columnTitle = "ZY"
**Output:** 701Example 4:
**Input:** columnTitle = "FXSHRXW"
**Output:** 2147483647Constraints:
1 <= columnTitle.length <= 7columnTitleconsists only of uppercase English letters.columnTitleis in the range["A", "FXSHRXW"].
ac
class Solution {
public int titleToNumber(String s) {
// edge cases
if (s == null || s.length() == 0) return 0;
// iterate
int res = 0;
for (int i = 0; i < s.length(); i++) {
char c = Character.toUpperCase(s.charAt(i));
int val = c - 'A' + 1;
// not A-Z character
if (val < 1 || val > 26) return 0;
res = res * 26 + val;
}
return res;
}
}Last updated
Was this helpful?