Excel Sheet Column Number 分类: Leetcode 2015-01-15 11:15 71人阅读 评论(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) {
int len=s.length();
int i,j;
int sum=0;
for(i=0;i<len;i++)
{
sum*=26;
sum+=s[i]-'A'+1;
}
return sum;
}
};版权声明:本文为博主原创文章,未经博主允许不得转载。

浙公网安备 33010602011771号