(python) Get range address script for Excel

xlsx_range_address.py

import string

def get_range_address(row, col):
    """Convert to range address string

    ex)
       (4, 1)  => 'A4'
       (1, 52) => 'AZ1'

    Same as follows：
    xlwings.Range((row, col)).get_address(False, False)

    This is fast. but this allow to get invalid address(: 'A0', 'XYZ72').
    """

    def _address_char_generator(row, col):
        """Return chars of address string

        returned reversed chars
        ex)
           (4, 1)  => ['4', 'A']      ... A4
           (1, 52) => ['1', 'Z', 'A'] ... AZ1
        """
        yield str(row)
        numbers = string.ascii_uppercase
        n = len(numbers)
        while col > 0:
            yield numbers[col % n - 1]
            col = (col - 1) // n
    chars = tuple(_address_char_generator(row, col))
    return ''.join(reversed(chars))