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
这道题实际上是一个进制转换问题,把26进制数转换为10进制的数,就不多说了,代码如下:
int result=0;
for(int i=0;i<s.length();i++){
result = result*26+(s.charAt(i)-'A'+1);
}
return result;
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
这两道题类似,这是把10进制转换为26进制,代码如下:
String res = "";
while(n>0)
{
res = (char)((n-1)%26+'A') + res;
n = (n-1)/26;
}
return res;