Pythonで罫線付き表の範囲を自動取得する方法｜openpyxl活用

import openpyxl

# 実線で囲われたセルの範囲を取得する
class Get_border_cell():
    def __init__(self, init_row, init_col, wb, ws):
        self.wb = wb
        self.ws = ws
        self.init_row = init_row
        self.init_col = init_col
        self.max_row = self.ws.max_row+1
        self.max_col = self.ws.max_column+1

    # 上を見ていき実線となる行を取得
    def get_border_top(self):
        row_top = None
        for row in range(self.init_row, 1, -1):
            if self.ws.cell(row=row, column=self.init_col).border.top.style == "thin":
                row_top = row
                break
        return row_top

    # 下を見ていき実線となる行を取得
    def get_border_bottom(self):
        row_bottom = None
        for row in range(self.init_row, self.max_row):
            if self.ws.cell(row=row, column=self.init_col).border.bottom.style == "thin":
                row_bottom = row
                break
        return row_bottom
    
    # 左を見ていき実線となる列を取得
    def get_border_left(self):
        col_left = None
        for col in range(self.init_col, 0, -1):
            if self.ws.cell(row=self.init_row, column=col).border.left.style == "thin":
                col_left = col
                break
        return col_left

    # 右を見ていき実線となる列を取得
    def get_border_right(self):
        col_right = None
        for col in range(self.init_col, self.max_col):
            if self.ws.cell(row=self.init_row, column=col).border.right.style == "thin":
                col_right = col
                break
        return col_right

    # 行・列を再定義する際に使用
    def set_position(self, row, col):
        self.init_row = row
        self.init_col = col
        
        
if __name__ == "__main__":
    filePath = r"sample.xlsx"
    wb = openpyxl.load_workbook(filePath)
    ws = wb.active

    cell_border = Get_border_cell(init_row=6, init_col=5, wb=wb, ws=ws)

    print(f"上:{cell_border.get_border_top()}行")
    print(f"下:{cell_border.get_border_bottom()}行")
    print(f"左:{cell_border.get_border_left()}列")
    print(f"右:{cell_border.get_border_right()}列")

import openpyxl

filePath = r"sample.xlsx"
wb = openpyxl.load_workbook(filePath)
ws = wb.active

cell_border = Get_border_cell(init_row=6, init_col=5, wb=wb, ws=ws)

top = cell_border.get_border_top()
bottom = cell_border.get_border_bottom()
left = cell_border.get_border_left()
right = cell_border.get_border_right()

def get_border_top(self):
    row_top = None
    for row in range(self.init_row, 1, -1):
        if self.ws.cell(row=row, column=self.init_col).border.top.style == "thin":
            row_top = row
            break
    return row_top

print(f"上:{top}行")
print(f"下:{bottom}行")
print(f"左:{left}列")
print(f"右:{right}列")