@albert, You need to becareful when doing the divide, because there is no ZERO. (Z -> AA not Z->A0). here is the code:
public static String ExcelMapIntToStr(int n) { StringBuilder sb = new StringBuilder(); while(n>0) { sb.append((char)(('A' - 1) + (n-1)%26 + 1)); n = (n-1)/26; } return sb.reverse().toString(); } public static int ExcelMapStrToInt(String str) { int val = 0; int base = 1; for(int i = str.length() - 1; i>=0; i--) { val += (str.charAt(i) - ('A' - 1))*base; base *= 26; } return val; } On Tue, Feb 1, 2011 at 10:39 AM, albert theboss <alberttheb...@gmail.com>wrote: > Simply L division by 26 gives the answer ... > like decimal to binary conversion thats it > > -- > You received this message because you are subscribed to the Google Groups > "Algorithm Geeks" group. > To post to this group, send email to algogeeks@googlegroups.com. > To unsubscribe from this group, send email to > algogeeks+unsubscr...@googlegroups.com<algogeeks%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/algogeeks?hl=en. > -- You received this message because you are subscribed to the Google Groups "Algorithm Geeks" group. To post to this group, send email to algogeeks@googlegroups.com. To unsubscribe from this group, send email to algogeeks+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/algogeeks?hl=en.