Excel Sheet Column Number (Java)
来源:互联网 发布:知乎 经典电影 编辑:程序博客网 时间:2024/06/04 23:33
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
Source
public class Solution { public int titleToNumber(String s) { int i,num = 0; i = 0; while( i < s.length()){ if(s.charAt(i) != 'Z'){ num = num * 26 + s.charAt(i) - 65 + 1; } else num = num * 26 + 26; i++; } return num; }}
Test
public static void main(String[] args){ System.out.println(new Solution().titleToNumber("AA")); }
0 0
- Excel Sheet Column Number (Java)
- Excel Sheet Column Number(java)
- Java-Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- excel Sheet Column Number
- Flex 全屏
- C# 读取xml文件忽略xml文件的注释
- ios 初学小结
- 97去掉ScrollVIew拉到尽头时再拉的阴影效果
- HDU 4006 The kth great number 【优先队列求第K大数】
- Excel Sheet Column Number (Java)
- java操作xml----dom4j
- unity3D__总结
- 【一步步学习MongoDB】——MongoDB简单介绍(一)
- 2014年的最后一天
- 回顾2014,设想2015
- 『HTML5梦幻之旅』 - 跟随歌曲显示当前歌词
- getopt() 函数使用方法
- Visual Basic 语言参考 ------类型转换函数