给定一个Excel表格中的列名称,返回其相应的列序号。
例如,
A -> 1 B -> 2 C -> 3 ... Z -> 26 AA -> 27 AB -> 28 ...
示例 1:
输入: "A" 输出: 1
示例 2:
输入: "AB" 输出: 28
示例 3:
输入: "ZY" 输出: 701
#!/usr/bin/python3
# -*- coding: utf-8 -*-
# @Time: 2018/8/1
# @Author: xfLi
# 与168题逆向推导
def titleToNumber(s):
"""
:type s: str
:rtype: int
"""
n = 0
for i in s:
n = n * 26 + ord(i) - ord('A') + 1
return n
if __name__ == '__main__':
s = 'AB'
result = titleToNumber(s)
print(result)