Get dynamic active range

​​
​

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
​

Consolidate files

FAO

Last modified 1mo ago