Code Example: Freezing Panes in Excel

from ironxl import * # Load the Excel workbook workbook = WorkBook.Load("sample.xls") worksheet = workbook.WorkSheets[0] # Create freeze pane from column(A-B) and row(1-3) worksheet.CreateFreezePane(2, 3) # Overwriting freeze or split pane to column(A-E) and row(1-5) as well as applying prescroll # The column will show E, G, ... and the row will show 5, 8, ... worksheet.CreateFreezePane(5, 5, 6, 7) # Save changes with the created freeze panes workbook.SaveAs("createFreezePanes.xls") # Remove all existing freeze or split pane worksheet.RemovePane()

Freeze Panes in Excel

The code example above shows how to create a freeze pane in Excel using IronXL for Python, locking rows and columns so they remain visible while scrolling. This is a valuable feature for keeping header rows or label columns in place when reviewing large datasets.

`CreateFreezePane(column, row)`

The first CreateFreezePane overload takes a column count and a row count to define the frozen area. For example, worksheet.CreateFreezePane(1, 4) creates a freeze pane covering column A and rows 1–4.

`CreateFreezePane(column, row, subsequentColumn, subsequentRow)`

This overload creates a freeze pane and also applies pre-scrolling to the worksheet. For example, worksheet.CreateFreezePane(5, 2, 6, 7) freezes columns A–E and rows 1–2, with the view scrolled to show 1 additional column and 5 additional rows. When the worksheet is first opened, it will display columns A–E, G–... and rows 1–2, 8–...

If you work with large data tables in Excel, freezing rows or columns keeps important labels visible while scrolling through the rest of the worksheet.