Knowee
Questions
Features
Study Tools

Given an integer columnNumber, return its corresponding column title as it appears in an Excel sheet.For example:A -> 1B -> 2C -> 3...Z -> 26AA -> 27AB -> 28 ... Example 1:Input: columnNumber = 1Output: "A"Example 2:Input: columnNumber = 28Output: "AB"Example 3:Input: columnNumber = 701Output: "ZY" Constraints:1 <= columnNumber <= 231 - 1

Question

Given an integer columnNumber, return its corresponding column title as it appears in an Excel sheet.For example:A -> 1B -> 2C -> 3...Z -> 26AA -> 27AB -> 28 ... Example 1:Input: columnNumber = 1Output: "A"Example 2:Input: columnNumber = 28Output: "AB"Example 3:Input: columnNumber = 701Output: "ZY" Constraints:1 <= columnNumber <= 231 - 1

🧐 Not the exact question you are looking for?Go ask a question

Solution

Para resolver este problema, podemos utilizar un enfoque similar al de convertir un número decimal a una base diferente, en este caso, una base 26. Aquí están los pasos detallados para convertir un número de columna a su correspondiente título de columna en una hoja de Excel:

  1. Inicializar una cadena vacía result para almacenar el título de la columna.
  2. Mientras columnNumber sea mayor que 0:
    • Restar 1 de columnNumber para ajustar el índice a 0.
    • Calcular el residuo de columnNumber dividido por 26. Este residuo nos dará la posición de la letra en el alfabeto (0 para 'A', 1 para 'B', ..., 25 para 'Z').
    • Convertir el residuo a la letra correspondiente y agregarla al inicio de result.
    • Dividir columnNumber por 26 y actualizar su valor.
  3. Devolver result como el título de la columna.

Aquí está el código que implementa estos pasos:

def convertToTitle(columnNumber):
    result = ""
    while columnNumber > 0:
        columnNumber -= 1
        remainder = columnNumber % 26
        result = chr(65 + remainder) + result
        columnNumber //= 26
    return result

# Ejemplos de uso
print(convertToTitle(1))   # Salida: "A"
print(convertToTitle(28))  # Salida: "AB"
print(convertToTitle(701)) # Salida: "ZY"

Explicación de los ejemplos:

  • Para columnNumber = 1, el resultado es "A".
  • Para columnNumber = 28, el resultado es "AB".
  • Para columnNumber = 701, el resultado es "ZY".

This problem has been solved

Similar Questions

Spreadsheet columns are easily identified by:*1 pointRoman numeralsnumbersletterscolours

In Excel, Columns are generally referred by...Select one:a.English Alphabetsb.Numbersc.Combination of Alphabets and numbersd.None of the above

Excel uniquely identifies cells within a worksheet with a cell name:AColumn numbers and row lettersBCell locator coordinatesCColumn letters and row numbersDCell names

Each cell in a Microsoft Office Excel document is referred to by its cell address, which is the ____________ ?cell's column label cell's column label and worksheet tab name cell's row label cell's row and column labels

From the following list, select the term that is used to refer to the column name data that is storedwithin the topmost row of an Excel table.*Start RowHeader RowInitial Values Row

1/1

Upgrade your grade with Knowee

Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.