All Downloads are FREE. Search and download functionalities are using the official Maven repository.

g0101_0200.s0171_excel_sheet_column_number.readme.md Maven / Gradle / Ivy

There is a newer version: 1.30
Show newest version
171\. Excel Sheet Column Number

Easy

Given a string `columnTitle` that represents the column title as appears in an Excel sheet, return _its corresponding column number_.

For example:

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

**Example 1:**

**Input:** columnTitle = "A"

**Output:** 1

**Example 2:**

**Input:** columnTitle = "AB"

**Output:** 28

**Example 3:**

**Input:** columnTitle = "ZY"

**Output:** 701

**Constraints:**

*   `1 <= columnTitle.length <= 7`
*   `columnTitle` consists only of uppercase English letters.
*   `columnTitle` is in the range `["A", "FXSHRXW"]`.




© 2015 - 2024 Weber Informatics LLC | Privacy Policy