美文网首页
171. Excel Sheet Column Number

171. Excel Sheet Column Number

作者: a_void | 来源:发表于2016-09-13 20:08 被阅读0次

Given a 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 
class Solution {
public:
    int titleToNumber(string s) {
        if(s.size() <= 0) return 0;
        int col = s[0] - 'A' + 1;
        for(int i=1;i<s.size();i++){
            col = col * 26 + s[i] - 'A' + 1;
        }
        return col;
    }
};

相关文章

网友评论

      本文标题:171. Excel Sheet Column Number

      本文链接:https://www.haomeiwen.com/subject/vkamettx.html