Freeze Panes in Excel

VB C#

using IronXL;
using System.Linq;

WorkBook workBook = WorkBook.Load("sample.xls");
WorkSheet workSheet = workBook.WorkSheets.First();

// 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);

workBook.SaveAs("createFreezePanes.xls");

// Remove all existing freeze or split pane
workSheet.RemovePane();

Imports IronXL
Imports System.Linq

Private workBook As WorkBook = WorkBook.Load("sample.xls")
Private workSheet As WorkSheet = workBook.WorkSheets.First()

' 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)

workBook.SaveAs("createFreezePanes.xls")

' Remove all existing freeze or split pane
workSheet.RemovePane()

Install-Package IronXL.Excel

Freeze Panes in Excel

The code example above shows how to create freeze pane, locking rows and columns in place, allowing them to remain visible while scrolling. It is a very useful feature to keep the header column or row in place while quickly compare information.

`CreateFreezePane(column, row)`

The first CreateFreezePane method overload take column and row amount to create freeze pane based it. For example, workSheet.CreateFreezePane(1, 4) will make freeze pane from column(A) and row(1-4).

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

This overload create freeze pane based on the column and row amount provided as well as apply scrolling to the worksheet. For example, workSheet.CreateFreezePane(5, 2, 6, 7) will have freeze pane from column(A-E) and row(1-2) with 1 column and 5 row scroll. When the worksheet is first open it will show column A-E,G-... and the row will show 1-2,8-...

If you have a large table of data in Excel, it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest of the worksheet.

You can download a file project from this link.