171. Excel Sheet Column Number (Easy)

来源:互联网 发布:开源推荐系统 python 编辑:程序博客网 时间:2024/06/08 15:23

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 -> 1B -> 2C -> 3...Z -> 26AA -> 27AB -> 28

Solution:

C:

int titleToNumber(char* s) {    int len = strlen(s);    int i, j = 1, result = 0;    for(i = 0; i < len; i++, j *= 26) {        result += (s[len - i - 1] - 'A' + 1) * j;    }    return result;}
0 0
原创粉丝点击