def get_column_code_by_index(index):
    """
    根据索引编号，获取excel列编号
    :param index: 索引编号，从1开始
    :return:
    """
    if index > 16384 or index < 1:
        return ''
    charSize = 26
    indexName = ''
    for i in range(0, 5):
        tmp = index % charSize
        index = int((index - 1) / charSize)
        if tmp == 0:
            tmp = charSize
        indexName = chr(64 + tmp) + indexName
        if index <= 0:
            break
    return indexName
