LeetCode 171/168 Excel Sheet Column Number/Title

171 Excel Sheet Column Number

Related to question Excel Sheet Column Title

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 

public class Solution {
    public int titleToNumber(String s) {
        if (s == null) return 0;
        else{
            char [] temp = s.toCharArray();
            int sum = 0;
            for(int i = temp.length-1; i >= 0; i--) {
              sum = sum + ((int)(temp[i]-64))*(int)(Math.pow(26,temp.length-1-i));
            }
            return sum;
        }
    }
    public static void main (String args[]){
        
    }
}

168 Excel Sheet Column Title

 Given a positive integer, return its corresponding column title as appear in an Excel sheet.

For example:

    1 -> A
    2 -> B
    3 -> C
    ...
    26 -> Z
    27 -> AA
    28 -> AB

</pre><pre name="code" class="java">public class Solution {
    public String convertToTitle(int n) {
        if (n <= 0) return String.valueOf(0);
        else {
            if(n<=26) return String.valueOf((char)(n+64));
            else return convertToTitle((n-1)/26)+String.valueOf((char)((n-1)%26+65));
        }
    }
    public static void main(String args[]){
        
    }
}