[LeetCode]171. Excel Sheet Column Number

最新推荐文章于 2024-02-17 11:47:40 发布

原创最新推荐文章于 2024-02-17 11:47:40 发布 · 220 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍如何将Excel表格中的列名转换为对应的序号，通过类26进制加法实现列名到序号的映射。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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

思路：类似于26进制加法

public class Solution {
    public int titleToNumber(String s) {
        if (s == null) return 0;
            char [] temp = s.toCharArray();
            int sum = 0;
            for(int i = temp.length-1; i >= 0; i--) {
              sum = sum + ((int)(temp[i]-64))*(int)(Math.pow(26,temp.length-1-i));
            }
            return sum;
        }

}