openpyxl、xlrd获取工作表中指定内容首次出现的行列号_openpyxl 根据单元格的内容获取行号-CSDN博客

本文介绍了使用Python库openpyxl和xlrd分别在xlsx和xls文件中实现查找指定内容所在的行号和列号的方法，适用于数据处理和文件操作场景。

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

分别对xlsx和xls文件进行区分行号和列号的返回

本文所用openpyxl、xlrd为python三方库，下载安装可直接cmd执行pip install openpyxl、pip install openpyxl。


# 获取指定内容所在单元格的行列 path：对应文件路径 sheet：对应sheet名称 character：指定内容
def get_row_xlsx(path, sheet, character):  
    import openpyxl
    wb = openpyxl.load_workbook(path)
    st = wb[sheet]
    for x in range(1, st.max_row + 1):
        for y in range(1, st.max_column + 1):
            if st.cell(x, y).value is not None:
                text = st.cell(x, y).value
                if character == str(text):
                    row = x
                    return row


def get_column_xlsx(path, sheet, character):
    import openpyxl
    wb = openpyxl.load_workbook(path)
    st = wb[sheet]
    for x in range(1, st.max_row + 1):
        for y in range(1, st.max_column + 1):
            if st.cell(x, y).value is not None:
                text = st.cell(x, y).value
                if character == str(text):
                    col = y
                    return col


def get_row_xls(path, sheet, character):
    import xlrd
    wb = xlrd.open_workbook(path)
    st = wb.sheet_by_name(sheet)
    for x in range(st.nrows):
        for y in range(st.ncols):
            if st.cell_value(x, y) is not None:
                text = st.cell_value(x, y)
                if character == str(text):
                    row = x
                    return row


def get_column_xls(path, sheet, character):
    import xlrd
    wb = xlrd.open_workbook(path)
    st = wb.sheet_by_name(sheet)
    for x in range(st.nrows):
        for y in range(st.ncols):
            if st.cell_value(x, y) is not None:
                text = st.cell_value(x, y)
                if character == str(text):
                    col = y
                    return col

原创文章，转载请注明出处，谢谢配合！