Excel 列序数转列字母表达

function printString(n){
    let arr = [];
    let i = 0;
 
    // Step 1: Converting to number assuming
    // 0 in number system
    while (n) {
        arr[i] = n % 26;
        n = Math.floor(n / 26);
        i++;
    }
 
    // Step 2: Getting rid of 0, as 0 is
    // not part of number system
    for (let j = 0; j < i - 1; j++) {
        if (arr[j] <= 0) {
            arr[j] += 26;
            arr[j + 1] = arr[j + 1] - 1;
        }
    }
    let ans = '';
    for (let j = i; j >= 0; j--) {
        if (arr[j] > 0)
            ans += String.fromCharCode(65 + arr[j] - 1);
    }
 
    document.write(ans + "<br>");
}
 

printString(26);//Z

printString(51);//AY

printString(100);//CV 

 

C#实现：

static string ColumnIndexToColumnLetter(int colIndex)
{
    int div = colIndex;
    string colLetter = String.Empty;
    int mod = 0;
 
    while (div > 0)
    {
        mod = (div - 1) % 26;
        colLetter = (char)(65 + mod) + colLetter;
        div = (int)((div - mod) / 26);
    }
    return colLetter;
}

string columnLetter = ColumnIndexToColumnLetter(100); // returns CV