获取给定范围内每行的最后一个填充单元格

import openpyxl

def get_last_filled_cell(range_start, range_end):
    wb = openpyxl.load_workbook('your_file.xlsx')  # 替换为你的文件路径
    sheet = wb.active

    last_filled_cells = []

    for row in sheet.iter_rows(min_row=range_start, max_row=range_end):
        last_filled_cell = None
        for cell in row:
            if cell.value is not None:
                last_filled_cell = cell.column

        last_filled_cells.append(last_filled_cell)

    return last_filled_cells