excel列序号与列名称的映射关系是:
1->A
1->A
2->B
...
27->AA
28->AB
...
数据范围:
function ExcelTitle(n) { let v = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"; let z = 0; let a = ""; while (n >= 1) { if (n % 26 !== 0) { a = v[(n % 26) - 1] + a; n = (n - (n % 26)) / 26; } else { a = v[25] + a; n = n / 26 - 1; } } return a; } module.exports = { ExcelTitle: ExcelTitle, };