获取excel表指定的内容（python）

目录

1 代码

2 表格内容

3 结果

1 代码

import xlrd


def get_content(inpath, index):
    data = xlrd.open_workbook(inpath, encoding_override='utf-8')
    table = data.sheets()[0]
    nrows = table.nrows
    ncols = table.ncols
    cols_info = []
    for i in range(0, nrows):
        all_data = table.row_values(i)
        result = all_data[index]
        if result != "":
            cols_info.append(result)
    return cols_info


if __name__ == '__main__':
    info_1 = get_content("1.xlsx", 0)
    print(info_1)
    info_2 = get_content("1.xlsx", 1)
    print(info_2)

2 表格内容

3 结果