Number to Spreadsheet Column

Problem

Convert a positive column number to its spreadsheet column title, where 1 is A, 26 is Z, 27 is AA and so on.

Repeatedly take (n - 1) modulo 26 to get the letter offset and divide n - 1 by 26, then reverse the collected letters. Assume n >= 1.

Hint

Subtracting 1 converts the 1-based title system into ordinary base-26 digits.

case 1

in: [1]

expected: "A"

case 2

in: [26]

expected: "Z"

case 3

in: [27]

expected: "AA"

case 4

in: [701]

expected: "ZY"

case 5

in: [52]

expected: "AZ"

case 6

in: [703]

expected: "AAA"

Starter codePython

def number_to_column(n):
    # Your code here
    pass

6 test cases · run your code against them in the editor