取最小值在一定范围内的单元格的值所在的单元格

import openpyxl

def find_min_cell(file_path, sheet_name, range):
    workbook = openpyxl.load_workbook(file_path)
    sheet = workbook[sheet_name]
    min_value = float('inf')  # 初始化最小值为正无穷大
    min_cell = None  # 初始化最小值所在的单元格

    for row in sheet[range]:
        for cell in row:
            if cell.value is not None and cell.value < min_value:
                min_value = cell.value
                min_cell = cell

    return min_cell

# 示例用法
file_path = 'data.xlsx'
sheet_name = 'Sheet1'
range = 'A1:C3'
min_cell = find_min_cell(file_path, sheet_name, range)
print(f"The minimum value is {min_cell.value} and it is located at {min_cell.coordinate}.")