excel Sheet Column Number
来源:互联网 发布:lex js语法解析 编辑:程序博客网 时间:2024/05/17 08:07
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
Credits:
Special thanks to @ts for adding this problem and creating all test cases.
public class Solution {
public int titleToNumber(String s) {
}
}
该题和
Excel Sheet Column Title
对应,不过是反过来了,给你一个excel列的名字,返回起列数。
public static int titleToNumber(String s) { if(s==null) return 0; int result=0; for(int i=s.length()-1;i>=0;i--){ result +=Math.pow(26, s.length()-1-i)*(s.charAt(i)-'A'+1); } return result; }
0 0
- 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
- Excel Sheet Column Number
- Excel Sheet Column Number
- studio导入libraries包
- 虚函数与多态
- Microsoft.Jet.OleDB.4.0
- Same Tree
- POJ 3083 BFS+DFS
- excel Sheet Column Number
- windows7 内部版本7601 此windows副本不是正版 ---解决方案
- Merge Sorted Array
- Linux 任务调度策略
- IFeatureClassManage接口更新图层全图显示时的范围
- (编译原理)C++源代码单词扫描程序(词法分析)
- Remove Duplicates from Sorted List
- #295 (div.2) E.Pluses everywhere
- Climbing Stairs