本文共 1015 字，大约阅读时间需要 3 分钟。
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 -> 1B -> 2C -> 3...Z -> 26AA -> 27AB -> 28
class Solution(object): def titleToNumber(self, s): Array_=list(s) Array_.reverse() s=0 for i in range(len(Array_)): s+=(ord(Array_[i])-ord('A')+1)*(26**i) return s leetcode 168.[math] Excel Sheet Column Title
Given a positive integer, return its corresponding column title as appear in an Excel sheet.For example:
1 -> A2 -> B3 -> C26 -> Z27 -> AA28 -> AB
class Solution(object): def convertToTitle(self, n): dict=['Z','A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y'] ans=[] while n!=0: ans.append(dict[n%len(dict)]) tmp=n%len(dict) if tmp==0: tmp=len(dict) n=(n-tmp)/len(dict) ans.reverse() s=''.join(ans) return s
转载地址：http://czqmi.baihongyu.com/