Skip to content
Programming101
Programming101

Learn everything about programming

  • Home
  • CS Subjects
    • IoT – Internet of Things
    • Digital Communication
    • Human Values
  • Programming Tutorials
    • C Programming
    • Data structures and Algorithms
  • HackerRank Solutions
    • HackerRank Algorithms Solutions
    • HackerRank C problems solutions
    • HackerRank C++ problems solutions
    • HackerRank Java problems solutions
    • HackerRank Python problems solutions
Programming101
Programming101

Learn everything about programming

Leetcode Excel Sheet Column Number problem solution

YASH PAL, 31 July 2024

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

Post navigation

Previous post
Next post
  • How AI Is Revolutionizing Personalized Learning in Schools
  • GTA 5 is the Game of the Year for 2024 and 2025
  • Hackerrank Day 5 loops 30 days of code solution
  • Hackerrank Day 6 Lets Review 30 days of code solution
  • Hackerrank Day 14 scope 30 days of code solution
©2025 Programming101 | WordPress Theme by SuperbThemes