Excel Sheet Column Number

Excel Sheet Column Number

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 

solution (其实和数数一个道理)

int titleToNumber(char* s) {
    char *p=s;
    char *q=s+strlen(s)-1;
    int num=0;
    int result=0;
    while(q-p>=0)
    {
        result+=pow(26,num)*(*q-'@');
        ++num;
        --q;
    }
    return result;
}