LeetCode:Excel Sheet Column Number

来源:互联网 发布:数据分析兼职平台 编辑:程序博客网 时间:2024/05/18 03:02

Excel Sheet Column Number

 Total Accepted: 31455 Total Submissions: 86178My Submissions

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.

Hide Tags
 Math
进制转换:number = number * 26(进制) + tmp(对应每一位的数值);
 public int titleToNumber(String s) {        int ans=0;        for(int i=0;i<s.length();i++){            ans=ans*26+s.charAt(i)-'A'+1;        }        return ans;}


0 0
原创粉丝点击