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}
*/
varcolumnIndexToRangeName = function(index) {
vardividend = index + 1;
varname = '';
varmodulo;
while(dividend > 0) {
modulo = (dividend - 1) % 26;
name = String.fromCharCode(65 + modulo) + name;
dividend = Math.round((dividend - modulo) / 26);
}
returnname;
}
0
Veselin Tsvetanov
Telerik team
answered on 21 Jun 2017, 01:07 PM
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.
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.