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
原创粉丝点击