Breaking News: Grepper is joining You.com. Read the official announcement!

jvascript number to column letter

Web Surfer answered on July 6, 2022 Popularity 3/10 Helpfulness 10/10

answer jvascript number to column letter

jvascript number to column letter

Comment

/**
 * Convert a whole number that is more than zero to a spreadsheet column letter. eg. 1 -> A
 * Source: https://stackoverflow.com/questions/45787459/convert-number-to-alphabet-string-javascript/45787487
 * 
 * @param {Number} num - (required) The number to convert to a spreadsheet column letter. Must be greater than zero.
 *
 * @returns {(String|undefined)} The spreadsheet column letter or undefined.
 */
function numToSSColumnLetter(num) {
  let columnLetter = "",
    t;

  while (num > 0) {
    t = (num - 1) % 26;
    columnLetter = String.fromCharCode(65 + t) + columnLetter;
    num = (num - t) / 26 | 0;
  }
  return columnLetter || undefined;
}

Popularity 3/10 Helpfulness 10/10 Language javascript

Source: stackoverflow.com

Tags: javascript letter

Link to this answer
Share Copy Link