项目中需要将数据导出excel,单独设置某些单元格的样式,,将 数字转正excel中的列A、列B、列AB等等
const excelSignStr = (num) => {
let result = "";
num++;
num = num <= 0 ? 1 : num;
while (num > 0) {
let m = num % 26;
if (m == 0) m = 26;
result = String.fromCharCode(m + 64) + result;
num = (num - m) / 26;
}
console.log(result);
return result;
};