LeetCode:Excel Sheet Column Number

时间：2016-05-22 12:11:17 收藏：0 阅读：121

Excel Sheet Column Number

Total Accepted: 80221 Total Submissions: 190904 Difficulty: Easy

Related to question Excel Sheet Column Title

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

Credits:
Special thanks to @ts for adding this problem and creating all test cases.

Subscribe to see which companies asked this question

Hide Tags

Math

Hide Similar Problems

(E) Excel Sheet Column Title

c code:

int titleToNumber(char* s) {
    int size = strlen(s);
    int ret = 0;
    for(int i=0;i<size;i++) {
        ret = ret * 26 + s[i] - 'A' + 1;
    }
    return ret;
}

原文：http://blog.csdn.net/itismelzp/article/details/51473894