本文共 674 字,大约阅读时间需要 2 分钟。
Excel Sheet Column Number
Related to question
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 for adding this problem and creating all test cases.
public class Solution { public int titleToNumber(String s) { int len = s.length(); if (len == 0) return 0; int sum = 0; for (int i = len - 1; i >= 0; i--) { sum += (s.charAt(i) - 'A' + 1) * GetCardinalNum(len - 1 - i); } return sum; } public int GetCardinalNum(int n) { int tmp = 1; for (int i = 1; i <= n; i++) { tmp = tmp * 26; } return tmp; }}
转载地址:http://wnuni.baihongyu.com/