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

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>