Excel_Get_dynamic_active_range.md

Template request | Bug report | Generate Data Product

Tags: #excel #openpyxl #active-range #finance #snippet #dataframe

Author: Florent Ravenel

Description: This notebook provides a method for dynamically retrieving the active range of an Excel worksheet.

Input

Import libraries

from openpyxl import load_workbook
from openpyxl.utils import get_column_letter

Setup your Excel parameters

excel_path = "Excel_Template.xlsx"

Model

Load Excel file and get active ws object

wb = load_workbook(excel_path)
ws = wb.active
ws

Get active range

def get_active_range(ws):
    max_row = ws.max_row
    max_col = get_column_letter(ws.max_column)
    active_range = f"A1:{max_col}{max_row}"
    return active_range


active_range = get_active_range(ws)

Output

Display result

active_range