Package g0101_0200.s0171_excel_sheet_column_number

Class Solution

java.lang.Object
g0101_0200.s0171_excel_sheet_column_number.Solution
public class Solution extends java.lang.Object
171 - Excel Sheet Column Number.

Easy

Given a string columnTitle that represents the column title as appear 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

Example 4:

Input: columnTitle = “FXSHRXW”

Output: 2147483647

Constraints:

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

  • Constructor Summary

    Constructors
    Constructor
    Description
    Solution()
     

  • Method Summary

    Modifier and Type
    Method
    Description
    int
    titleToNumber(java.lang.String s)
     

    Methods inherited from class java.lang.Object

    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

  • Constructor Details

    • Solution

      public Solution()

  • Method Details

    • titleToNumber

      public int titleToNumber(java.lang.String s)