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
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:
- Inicializar una cadena vacía
resultpara almacenar el título de la columna. - Mientras
columnNumbersea mayor que 0:- Restar 1 de
columnNumberpara ajustar el índice a 0. - Calcular el residuo de
columnNumberdividido 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
columnNumberpor 26 y actualizar su valor.
- Restar 1 de
- Devolver
resultcomo 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".
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
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.