leetcode-171 Excel Sheet Column Number

最新推荐文章于 2024-11-13 20:43:20 发布

Mr.Bean-Pig

最新推荐文章于 2024-11-13 20:43:20 发布

阅读量169

点赞数

分类专栏：算法题解文章标签： java LeetCode

本文链接：https://blog.csdn.net/z714405489/article/details/88380290

版权

算法题解专栏收录该内容

140 篇文章 0 订阅

订阅专栏

题目

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 
...

Example 1:

Input: “A”
Output: 1

Example 2:

Input: “AB”
Output: 28

Example 3:

Input: “ZY”
Output: 701

思路

这其实就是一个“26进制”，接下来只要把字母转换成数字即可——26进制转换成10进制。

代码

class Solution {
    public int titleToNumber(String s) {
    	char[] a = s.toCharArray();
    	
    	int sum = 0;
    	for(int i = a.length-1,bit = 0 ; i >= 0 ;i --,bit++){
    		sum+= (a[i]-'A'+1)*Math.pow(26,bit);

    	}
    	return sum;
        
    }
}

Runtime: 1 ms, faster than 100.00% of Java online submissions for Excel Sheet Column Number.
Memory Usage: 34.6 MB, less than 72.50% of Java online submissions for Excel Sheet Column Number.

修改后代码

class Solution {
    public int titleToNumber(String s) {
    	char[] a = s.toCharArray();
    	
    	int sum = 0;
    	for(int i = 0;i < a.length; i ++){
    		sum = sum*26 + a[i]-'A'+1 ;

    	}
    	return sum;
        
    }
}

Runtime: 1 ms, faster than 100.00% of Java online submissions for Excel Sheet Column Number.
Memory Usage: 34.5 MB, less than 78.44% of Java online submissions for Excel Sheet Column Number.