LeetCode Excel Sheet Column Number

最新推荐文章于 2020-09-30 02:55:01 发布

wdkirchhoff

最新推荐文章于 2020-09-30 02:55:01 发布

阅读量1.5k

点赞数

分类专栏： LeetCode 文章标签： leetcode

本文链接：https://blog.csdn.net/wdkirchhoff/article/details/44523511

版权

LeetCode 专栏收录该内容

46 篇文章 0 订阅

订阅专栏

Excel Sheet Column Number Total Accepted: 19547 Total Submissions: 52851 My Submissions Question Solution
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

很简单：AB==1*26+2

class Solution {
public:
    int titleToNumber(string s) {
        int sum=0;
        for(string::size_type i=0;i<s.size();++i)
        {
            sum=sum*26+s[i]-'A'+1;
        }
        return sum;
    }
};