Excel Sheet Column Number
来源:互联网 发布:可以免费发广告软件 编辑:程序博客网 时间:2024/06/05 14:09
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
public class Solution { public int titleToNumber(String s) { char arr[] = s.toCharArray(); int len = arr.length; int num = 0; if (len == 0){ return 0; } for (int i = 0; i < len; i ++){ num += (arr[i] - 64) * Math.pow(26, len - 1 - i); } return num; } }
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
- SCU 4426 Counting_3 (dp)
- R语言基础编程技巧汇编 - 21
- 69 个Spring 面试问题和答案 – 终极列表
- mysql/Java服务端对emoji的支持
- [ACM] HDU 1695 GCD (容斥原理)
- Excel Sheet Column Number
- 浅析Tomcat默认页面的设置
- webservice里的@queryparam、@pathparam、@DefaultValue使用介绍
- A. Vitaly and Strings
- JVM-2-loadClass(*)与Class.forName(*)
- jsp上传图片,并加以显示
- java工程添加类库
- ORCLE_基础十八(Shared Server)
- 随机数函数取样与概率