[LeetCode]168. Excel Sheet Column Title&171. Excel Sheet Column Number

168 . Excel Sheet Column Title
Easy

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 

3ms:

 public String convertToTitle(int n) {
        StringBuffer x = new StringBuffer();
        while(n>0){
            x.append((char)((n-1)%26+'A'));
            n = (n-1)/26;
        }
        return x.reverse().toString();
    }

171 . Excel Sheet Column Number
Easy

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 

3ms:

 public int titleToNumber(String s) {
        int len = s.length();
        int value = 0;
        for(int i=0;i<len;i++){
            char x = s.charAt(i);
            value = value*26+(x-'A')+1;
        }
        return value;
    }