Excel Columns Names Generator

by Anshul Pandey

JavaScript

var columnArr = new Array();
var columnDigits = 0;
var newACSII = 65;
function convertToColumns(columnIndex, count){
    if(count != columnIndex){
        if(count % 26 == 0){
            newACSII = 65;
            if(count == 26){
                columnDigits++;
            }
            if(columnDigits == 0){
                columnArr[columnDigits] = String.fromCharCode(parseInt(newACSII));
                
            }else if(columnDigits > 0 && columnArr[columnDigits-1] == 'Z'){
                columnArr[columnDigits-1] = 'A';
            }else if(columnDigits > 0 && (columnArr[columnDigits-1].charCodeAt(0)) >= 65 && (columnArr[columnDigits-1].charCodeAt(0)) < 90){
                columnArr[columnDigits-1] = String.fromCharCode(parseInt(columnArr[columnDigits-1].charCodeAt(0)+1));
            }
            
        }else{
            columnArr[columnDigits] = String.fromCharCode(parseInt(newACSII));
        }
        count++;
        newACSII++;
        if(count %26 == 0 && columnArr[columnDigits-1] == 'Z'){
            columnDigits++;
        }
        convertToColumns(columnIndex, count);
    }else{
    alert(columnArr);
    }
}

convertToColumns(57,0);