以 Pythonic 方式将 excel 或电子表格列字母转换为其数字

问题描述

是否有更 Pythonic 的方式将 excel 样式的列转换为数字(从 1 开始)?

Is there a more pythonic way of converting excel-style columns to numbers (starting with 1)?

最多两个字母的工作代码:

Working code up to two letters:

def column_to_number(c):
    """Return number corresponding to excel-style column."""
    number=-25
    for l in c:
        if not l in string.ascii_letters:
            return False
        number+=ord(l.upper())-64+25
    return number

代码运行:

>>> column_to_number('2')
False
>>> column_to_number('A')
1
>>> column_to_number('AB')
28

三个字母不起作用.

>>> column_to_number('ABA')
54
>>> column_to_number('AAB')
54

参考:问题用 C# 回答

推荐答案

有一种方法可以让它更像 Pythonic(使用三个或更多字母并使用更少的魔法数字):

There is a way to make it more pythonic (works with three or more letters and uses less magic numbers):

def col2num(col):
    num = 0
    for c in col:
        if c in string.ascii_letters:
            num = num * 26 + (ord(c.upper()) - ord('A')) + 1
    return num

并且作为单行使用 reduce(不检查输入并且可读性较差，所以我不推荐它):

And as a one-liner using reduce (does not check input and is less readable so I don't recommend it):

col2num = lambda col: reduce(lambda x, y: x*26 + y, [ord(c.upper()) - ord('A') + 1 for c in col])

这篇关于以 Pythonic 方式将 excel 或电子表格列字母转换为其数字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！