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[]){ } }
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[]){ } }