Topic |
Excel Sheet Column Title |
Pass Rate |
17.2% |
Difficulty |
Easy |
Given a positive integer, return its corresponding column title as appear in an Excel sheet.
For example:
1, A 2, B 3, C ... AA, Z
Excel Sheet column title and Excel Sheet column number is exactly the two inverse of the topic, in fact, is the conversion between 10 binary and 26 binary;
Idea:%26 each number to get that number, and then take N/26 to an integer, as long as the n>0 has been cycled, and special attention needs to be given to the case of Z (that is, divisible by 26);
Java code:
Public classSolution { PublicString Converttotitle (intN) {StringBuilder sb=NewStringBuilder (); if(n<0)returnsb.tostring (); while(n>0){ intX=n%26; if(x==0) {sb.append (Z); N--; }Else{sb.append (Char) (' A ' -1+x)); } N/=26; } returnsb.reverse (). toString (); }}
Leetcode----------Excel Sheet Column Title