Given a column title as appear in an Excel sheet, return its corresponding column number.
For example:
<pre>
A -> 1
B -> 2
C -> 3
...
Z -> 26
AA -> 27
AB -> 28
</pre>
这道题其实很像一道进制转换。
个位上的A代表1，B代表2，...,Z代表26
十位上的A代表26*1，B代表26*2，...，Z代表26*26
以此类推...
于是代码就呼之欲出了~
class Solution {
public:
int titleToNumber(string s) {
int res = 0;
int len = s.length();
for (int i=0;i<len;i++){
res = res*26+s[i]-'A'+1;
}
return res;
}
};
D93 171. Excel Sheet Column Number 题目链接 171. Excel Sheet ...
171. Excel Sheet Column Number Description Given a column...
171. Excel Sheet Column Number【思路】 进制换算；
171. Excel Sheet Column Number https://leetcode.com/probl...
Given a column title as appear in an Excel sheet, return ...
26进制转10进制：171. Excel Sheet Column Number 10进制转16进制：405. C...
题目地址：https://leetcode.com/problems/excel-sheet-column-num...
这个比较简单就是按公式就好了
Problem Given a column title as appear in an Excel sheet,...
问题 Related to question Excel Sheet Column TitleGiven a co...
本文标题：171 Excel Sheet Column Number
本文链接：https://www.haomeiwen.com/subject/fkioyttx.html
网友评论