Leetcode Excel Sheet Column Number problem solution

YASH PAL,

In this Leetcode Excel Sheet Column Number problem solution we have Given a string columnTitle that represents the column title as appears in an Excel sheet, return its corresponding column number.

Leetcode Excel Sheet Column Number problem solution

Problem solution in Python.

class Solution(object):
    def titleToNumber(self, s):
        """
        :type s: str
        :rtype: int
        """
        s=S[::-1]
        return sum([(ord(s[i])-64)*(26**i) for i in range(len(s))])

Problem solution in Java.

class Solution {
    public int titleToNumber(String s) {
        int len= s.length()-1;
        int res=0;
        for(int i=0;i<s.length();i++)
            res+=Math.pow(26,len-i)*(s.charAt(i)-64);
        return res;
        
    }
}

Problem solution in C++.

class Solution {
public:
    int titleToNumber(string s) {
        int ans=0,i=0;
        while(i<s.length())
            ans= ans*26 + (s[i++]-'A'+1);
        return ans;
    }
};

Problem solution in C.

#include<string.h>
int titleToNumber(char * s){
    int ans=0;
    int len=strlen(s);
    for(int i=0;i<len;i++){
        ans*=26;
        ans+=(s[i]-'A'+1);
    }
    return ans;
}

coding problems solutions