Excel Sheet Column Number

suchitra_13

Suchitra

Posted on August 11, 2020

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❤️

💖 💪 🙅 🚩
suchitra_13
Suchitra

Posted on August 11, 2020

Join Our Newsletter. No Spam, Only the good stuff.

Sign up to receive the latest update from our blog.

Related

Excel Sheet Column Number
java Excel Sheet Column Number

August 11, 2020