excel-sheet-column-number

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 a string <code>columnTitle</code> that represents the column title as appears in an Excel sheet, return its corresponding column number.

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: columnTitle = &quot;A&quot;
Output: 1
</pre>

Example 2:

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

Example 3:

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

&nbsp;
Constraints:

<ul>
	<li><code>1 &lt;= columnTitle.length &lt;= 7</code></li>
	<li><code>columnTitle</code> consists only of uppercase English letters.</li>
	<li><code>columnTitle</code> is in the range <code>[&quot;A&quot;, &quot;FXSHRXW&quot;]</code>.</li>
</ul>

titleToNumber

Excel Sheet Column Number

Excel Sheet Column Title

excel-sheet-column-title

Excel 表列名称

Cells in a Range on an Excel Sheet

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

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

Math

String

给你一个字符串&nbsp;<code>columnTitle</code> ，表示 Excel 表格中的列名称。返回 该列名称对应的列序号&nbsp;。

例如：

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

&nbsp;

示例 1:

<pre>
输入: columnTitle = "A"
输出: 1
</pre>

示例&nbsp;2:

<pre>
输入: columnTitle = "AB"
输出: 28
</pre>

示例&nbsp;3:

<pre>
输入: columnTitle = "ZY"
输出: 701</pre>

&nbsp;

提示：

<ul>
	<li><code>1 &lt;= columnTitle.length &lt;= 7</code></li>
	<li><code>columnTitle</code> 仅由大写英文组成</li>
	<li><code>columnTitle</code> 在范围 <code>["A", "FXSHRXW"]</code> 内</li>
</ul>