Excel_Get_dynamic_active_range.ipynb

Kernel: Python 3

Excel - Get dynamic active range

Give Feedback | Bug report

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

Author: Florent Ravenel

Last update: 2023-04-12 (Created: 2022-02-24)

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