171. Excel Sheet Column Number
来源:互联网 发布:大数据技术 原理 编辑:程序博客网 时间:2024/05/22 14:36
**问题描述:
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[] ss = s.toCharArray(); int sum=0; for(int i=0;i<ss.length;i++){ sum=26*sum+(ss[i]-'A'+1); } return sum; }}
0 0
- 171.Excel Sheet Column Number
- 171. Excel Sheet Column Number
- 171. Excel Sheet Column Number
- 171. Excel Sheet Column Number
- 171. Excel Sheet Column Number
- 171. Excel Sheet Column Number
- 171. Excel Sheet Column Number
- 171. Excel Sheet Column Number
- 171. Excel Sheet Column Number
- 171. Excel Sheet Column Number
- 171. Excel Sheet Column Number
- 171. Excel Sheet Column Number
- 171. Excel Sheet Column Number
- 171. Excel Sheet Column Number
- 171. Excel Sheet Column Number
- 171. Excel Sheet Column Number
- 171. Excel Sheet Column Number
- 171. Excel Sheet Column Number
- ubuntu on power服务器上安装docker binary package
- TokuMX will not run with transparent huge pages enabled.
- GLFW Keyboard keys
- iOS开发者账号总结
- Android中PopupWindow使用详解
- 171. Excel Sheet Column Number
- BigDecimal用法详解
- 服务与线程的区别
- Dmp文件导入(Imp命令)
- JDBC+MYSQL初始学习
- Swift 学习指南
- MongoDB
- php乱码问题
- 字符编码