给你一个整数 columnNumber ,返回它在 Excel 表中相对应的列名称。
例如:
A -> 1
B -> 2
C -> 3
…
Z -> 26
AA -> 27
AB -> 28
…
示例 1:
输入:columnNumber = 1
输出:“A”
示例 2:
输入:columnNumber = 28
输出:“AB”
示例 3:
输入:columnNumber = 701
输出:“ZY”
示例 4:
输入:columnNumber = 2147483647
输出:“FXSHRXW”
提示:
1 <= columnNumber <= 231 - 1
来源:力扣(LeetCode)
链接:https://leetcode-cn.com/problems/excel-sheet-column-title
著作权归领扣网络所有。商业转载请联系官方授权,非商业转载请注明出处。
var convertToTitle = function(columnNumber) {
let num = 0
let res = []
alphabet = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
let temp = 0
for (let i = 0; i < columnNumber; i++) {
temp += 26 ** i * 26
if (temp >= columnNumber) {
num = i + 1
break
}
}
for (let i = num - 1; i >= 0; i--) {
let this_v = parseInt(columnNumber / (26 ** i))
columnNumber = columnNumber - this_v * (26 ** i)
res.push(this_v)
}
if (res[res.length - 1] === 0) {
res[res.length - 1] = 26
res[res.length - 2] -= 1
}
res = res.map(item => alphabet[item-1])
return res.join('')
}
res = convertToTitle(52)
console.log(res)