Excel表列号
171. Excel Sheet Column Number Easy
Description
Given a column title as appear in an Excel sheet, return its corresponding column number.
example
For example:
A -> 1
B -> 2
C -> 3
...
Z -> 26
AA -> 27
AB -> 28
...
- Example 1:
Input: "A"
Output: 1
- Example 2:
Input: "AB"
Output: 28
- Example 3:
Input: "ZY"
Output: 701
题意
将所给大写字母按照规则转化为列数字
解题思路
看了规则后发现这题就是一个26进制转10进制的问题,不过A对应的是1而不是0,另外,这里的26进制是从A开始而不是0,要注意。
code
class Solution:
def titleToNumber(self, s: str) -> int:
res = 0
for i in s:
res = res*26 + ord(i) - 64
return res
其中:
ord(A) =65