Built-in function to convert column index to range letter format?

[Christopher]

Is there a built in function (couldn't find in the documentation) that will convert a column index to it's named range equivalent?

 

For example convert column 2 to "C", 3 to "D", 27 to "AB", etc.

[Christopher]

Still curious if this is built in, however, here's a function for anyone who might be looking:

/**
 * Translates an column index to its corresponding letter (range format).
 * @param {Number} index - The index of the column.
 * @returns {String}
 */
var columnIndexToRangeName = function (index) {
    var dividend = index + 1;
    var name = '';
    var modulo;
    while (dividend > 0) {
        modulo = (dividend - 1) % 26;
        name = String.fromCharCode(65 + modulo) + name;
        dividend = Math.round((dividend - modulo) / 26);
    }
    return name;
}

[Veselin Tsvetanov]

Hello Christopher,

The Spreadsheet widget does not expose a dedicated function, that would allow you to convert column index to its letter representation. The suggested custom implementation, however, is a viable approach when such is needed.

Regards,
Veselin Tsvetanov
Progress Telerik

[Doug]

Kendo spreadsheet supports row column notation, also known as "R1C1" notation.  So the range "C3:D8" is the same as "R3C3:R8C4", which is easier to determine programmatically.

[Noe]

telerik does not support R1C1

[Noe]

https://feedback.telerik.com/document-processing/1649321-add-support-for-r1c1-formula-style