LeetCode------Excel Sheet Column Number
来源:互联网 发布:excel无法黏贴数据 编辑:程序博客网 时间:2024/06/15 06:36
题目介绍
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) { int num=0; int max=1; int length=s.length(); char [] c =s.toCharArray(); int [] a =new int[length]; while(length!=1){ max*=26; length--; } for(int i=0;i<s.length();i++){ a[i]=(int)c[i]-64; num+=a[i]*max; max/=26; } return num; }}
题目的意思是其实就是将26进制转为10进制,每一位有对应的权值从低到高分别是26^0,26^1,26^2等等,再乘以对应为的值加起来就可以。比如说BA=2*26+1*1=53。英文数字对应的值就是相应英文字母的ASCII值减去A的ASCII值再加一。
Hot解法
public class Solution { public int titleToNumber(String s) { int result = 0; for (int i = 0; i < s.length(); i++){ result *= 26; result += ((s.charAt(i) - 'A') + 1); } return result; }}
0 0
- [leetcode]Excel Sheet Column Number
- leetcode:Excel Sheet Column Number
- LeetCode:Excel Sheet Column Number
- leetcode: Excel Sheet Column Number
- [LeetCode] Excel Sheet Column Number
- 【Leetcode】Excel Sheet Column Number
- 【Leetcode】Excel Sheet Column Number
- [Leetcode]Excel Sheet Column Number
- Leetcode: Excel Sheet Column Number
- [LeetCode]Excel Sheet Column Number
- LeetCode:《Excel Sheet Column Number 》
- LeetCode--Excel Sheet Column Number
- Leetcode: Excel Sheet Column Number
- 【LeetCode】Excel Sheet Column Number
- [leetcode] Excel Sheet Column Number
- Leetcode: Excel Sheet Column Number
- LeetCode-Excel Sheet Column Number
- Excel Sheet Column Number-LeetCode
- android 自学日记(五) ——ListView
- 【BZOJ2773】ispiti【CDQ分治】【线段树】
- HDU 2005 第几天?(水题)
- 26-Palindrome Number
- Android:EditText插入图片实现图文混排
- LeetCode------Excel Sheet Column Number
- maven
- 虚幻4 字符串char utf8转换
- JS常用的兼容方法
- Eclipse断点调试
- java学习第一步 sublime环境配置
- Node.js的TLS/SSL模块详解
- Software Quality and Testing in MySQL
- Java String、StringBuffer、StringBuilder深度剖析