Excel Sheet Column Number
来源:互联网 发布:淘宝售前和售后的区别 编辑:程序博客网 时间:2024/06/16 03:37
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) { StringBuilder stringBuilder=new StringBuilder(s);stringBuilder.reverse();int result=0; for(int i=0;i<stringBuilder.length();i++){ result+=(stringBuilder.charAt(i)-'A'+1)*(int)(Math.pow(26, i)); } 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
- 将十进制转换为任意进制的数
- CSS块级元素和行内元素
- Spring源码分析【8】-MyBatis注解方法不能重载
- iOS-分段控件控制页面切换
- System.out.println() 和 log4j 的 Logger 循环输出100万次。
- Excel Sheet Column Number
- PHP开发面试题目总结
- tornado 异步非阻塞 实验
- 金蝶打印时选择使用套打秒退
- linux菜鸟学习----MySQL导入.sql文件及常用命令
- DIV+CSS右列宽度自适应布局的不同实现方法
- 关于Keil编译后Code RO RW ZI !
- nginx配置优化+负载均衡+动静分离详解
- ShellExecute与ShellExecuteEx的用法