excel-sheet-column-title

java

python

python3

mysql

mssql

oraclesql

csharp

javascript

typescript

bash

swift

kotlin

dart

golang

ruby

scala

rust

racket

erlang

elixir

pythondata

postgresql

cangjie

Algorithms

Given an integer <code>columnNumber</code>, return its corresponding column title as it appears in an Excel sheet.

For example:

<pre>
A -&gt; 1
B -&gt; 2
C -&gt; 3
...
Z -&gt; 26
AA -&gt; 27
AB -&gt; 28 
...
</pre>

&nbsp;
Example 1:

<pre>
Input: columnNumber = 1
Output: &quot;A&quot;
</pre>

Example 2:

<pre>
Input: columnNumber = 28
Output: &quot;AB&quot;
</pre>

Example 3:

<pre>
Input: columnNumber = 701
Output: &quot;ZY&quot;
</pre>

&nbsp;
Constraints:

<ul>
	<li><code>1 &lt;= columnNumber &lt;= 231 - 1</code></li>
</ul>

convertToTitle

Excel Sheet Column Title

Excel Sheet Column Number

excel-sheet-column-number

Excel 表列序号

Cells in a Range on an Excel Sheet

cells-in-a-range-on-an-excel-sheet

Excel 表中某个范围内的单元格

Design Spreadsheet

design-spreadsheet

设计电子表格

Math

String

给你一个整数 <code>columnNumber</code> ，返回它在 Excel 表中相对应的列名称。

例如：

<pre>
A -> 1
B -> 2
C -> 3
...
Z -> 26
AA -> 27
AB -> 28 
...
</pre>

 

示例 1：

<pre>
输入：columnNumber = 1
输出："A"
</pre>

示例 2：

<pre>
输入：columnNumber = 28
输出："AB"
</pre>

示例 3：

<pre>
输入：columnNumber = 701
输出："ZY"
</pre>

示例 4：

<pre>
输入：columnNumber = 2147483647
输出："FXSHRXW"
</pre>

 

提示：

<ul>
	<li><code>1 <= columnNumber <= 231 - 1</code></li>
</ul>