首页 > 代码库 > Java-Excel Sheet Column Number

Java-Excel Sheet Column Number

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 
与Excel Sheet Column Title一样都是26进制的转换 代码如下:
public class Solution {    public int titleToNumber(String s) {        if(s.length()==0){            return 0;        }        int res=0;        for(int i=0;i<s.length();i++){            res=res*26+(s.charAt(i)-'A'+1);        }        return res;    }}

Java-Excel Sheet Column Number