DEV Community

Suchitra
Suchitra

Posted on

Excel Sheet Column Number

Given a 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 
...
Enter fullscreen mode Exit fullscreen mode

Example 1:

Input: "A"
Output: 1
Example 2:

Input: "AB"
Output: 28
Example 3:

Input: "ZY"
Output: 701

Constraints:

1 <= s.length <= 7
s consists only of uppercase English letters.
s is between "A" and "FXSHRXW".

Here is my solution:

 class Solution {
      public int titleToNumber(String s) {
         int result=0;
         for(char c:s.toCharArray())
             {
            int d=(int)(c)-'A'+1;

    result=result*26+d;

          }
       return result;

  }
  }
Enter fullscreen mode Exit fullscreen mode

This is a LeetCode August Challenge Question
HappyCoding❤️

Discussion (0)