DEV Community

Suchitra
Suchitra

Posted on

2 1

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

Top comments (0)

Postmark Image

Speedy emails, satisfied customers

Are delayed transactional emails costing you user satisfaction? Postmark delivers your emails almost instantly, keeping your customers happy and connected.

Sign up

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay