给你一个字符串 columnTitle ,表示 Excel 表格中的列名称。返回该列名称对应的列序号。
官方解法:进制转换(48ms/15.1MB)
https://leetcode-cn.com/problems/excel-sheet-column-number/solution/excelbiao-lie-xu-hao-by-leetcode-solutio-r29l/
class Solution:
def titleToNumber(self, columnTitle: str) -> int:
number, multiple = 0, 1
for i in range(len(columnTitle) - 1, -1, -1):
k = ord(columnTitle[i]) - ord("A") + 1
number += k * multiple
multiple *= 26
return number
力扣链接:https://leetcode-cn.com/leetbook/read/top-interview-questions-medium/xweb76/