Leetcode 171. Excel Sheet Column Number (Easy) (cpp)
Tag: Math
Difficulty: Easy
/*
171. Excel Sheet Column Number (Easy)
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
*/
class Solution {
public:
int titleToNumber(string s) {
int res = 0;
for (int i = 0; i < s.length(); i++) {
res = res * 26 + (s[i] - '@');
}
return res;
}
};

本文介绍了一种将Excel表格中的列标题转换为对应列号的算法实现。通过使用C++编程语言,该算法能够准确地将如'A'到'Z'、'AA'到'AZ'等列标题转换为其对应的数值形式,例如'A'对应1,'Z'对应26,'AA'对应27等。

195

被折叠的 条评论
为什么被折叠?



