How to Add Freeze Pane

using IronXL;
using System.Linq;

// Load an existing Excel workbook named "sample.xlsx"
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Get the first worksheet from the loaded workbook
WorkSheet workSheet = workBook.WorkSheets.First();

// Create a freeze pane in the worksheet. 
// This will freeze the columns from A to B (2 columns) and rows from 1 to 3 (3 rows).
// Parameters (2, 3) indicate that columns A to B and rows 1 to 3 will be frozen.
workSheet.CreateFreezePane(2, 3);

// Save the modifications to a new file named "createFreezePanes.xlsx"
workBook.SaveAs("createFreezePanes.xlsx");

Imports IronXL

Imports System.Linq



' Load an existing Excel workbook named "sample.xlsx"

Private workBook As WorkBook = WorkBook.Load("sample.xlsx")



' Get the first worksheet from the loaded workbook

Private workSheet As WorkSheet = workBook.WorkSheets.First()



' Create a freeze pane in the worksheet. 

' This will freeze the columns from A to B (2 columns) and rows from 1 to 3 (3 rows).

' Parameters (2, 3) indicate that columns A to B and rows 1 to 3 will be frozen.

workSheet.CreateFreezePane(2, 3)



' Save the modifications to a new file named "createFreezePanes.xlsx"

workBook.SaveAs("createFreezePanes.xlsx")

// The following code is intended to remove any freeze or split panes in an Excel worksheet.
// Ensure you are using an appropriate library like EPPlus or NPOI that allows for worksheet manipulation.

// Note: This example assumes you are using the EPPlus library for Excel manipulation.
// Make sure to install the EPPlus NuGet package if it's not already installed.

// Remove all existing freeze or split panes in the worksheet

// Typically, the worksheet variable should be an instance of an Excel worksheet object.
// Ensure that 'worksheet' is initialized and appropriately refers to the worksheet you wish to modify.
// Example: var worksheet = package.Workbook.Worksheets["Sheet1"];

if (worksheet != null) // Ensure that the worksheet object is not null
{
    worksheet.View.FreezePanes(1, 1); // This method removes any freeze panes applied to the worksheet
    worksheet.View.SplitPanes(null); // Set this method to null to remove any existing split panes
    
    // Note: If your library has different methods for adjusting panes, refer to its documentation.
}
else
{
    Console.WriteLine("The worksheet object is null. Please ensure it is initialized correctly.");
}

// Explanation:
// - `FreezePanes(1, 1)` typically resets the freeze panes applied to the worksheet, if these methods are available in the library you use.
// - `SplitPanes(null)` is assumed behavior for removing split panes; actual methods may differ based on library.
// Always consult the documentation of the library you're using to confirm these methods.

' The following code is intended to remove any freeze or split panes in an Excel worksheet.

' Ensure you are using an appropriate library like EPPlus or NPOI that allows for worksheet manipulation.



' Note: This example assumes you are using the EPPlus library for Excel manipulation.

' Make sure to install the EPPlus NuGet package if it's not already installed.



' Remove all existing freeze or split panes in the worksheet



' Typically, the worksheet variable should be an instance of an Excel worksheet object.

' Ensure that 'worksheet' is initialized and appropriately refers to the worksheet you wish to modify.

' Example: var worksheet = package.Workbook.Worksheets["Sheet1"];



If worksheet IsNot Nothing Then ' Ensure that the worksheet object is not null

	worksheet.View.FreezePanes(1, 1) ' This method removes any freeze panes applied to the worksheet

	worksheet.View.SplitPanes(Nothing) ' Set this method to null to remove any existing split panes



	' Note: If your library has different methods for adjusting panes, refer to its documentation.

Else

	Console.WriteLine("The worksheet object is null. Please ensure it is initialized correctly.")

End If



' Explanation:

' - `FreezePanes(1, 1)` typically resets the freeze panes applied to the worksheet, if these methods are available in the library you use.

' - `SplitPanes(null)` is assumed behavior for removing split panes; actual methods may differ based on library.

' Always consult the documentation of the library you're using to confirm these methods.

using IronXL;
using System.Linq;

// Load the Excel workbook from a specified file
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Get the first worksheet from the workbook
WorkSheet workSheet = workBook.WorkSheets.First();

// Create a freeze pane starting from column E (5th column) and row 5 (5th row).
// The scrolling will begin from column E (5th column) and row 5 (5th row),
// effectively freezing rows above and columns to the left of this cell.
workSheet.CreateFreezePane(5, 5, 6, 7);

// Save the modified workbook to a new file
workBook.SaveAs("createFreezePanes.xlsx");

Imports IronXL

Imports System.Linq



' Load the Excel workbook from a specified file

Private workBook As WorkBook = WorkBook.Load("sample.xlsx")



' Get the first worksheet from the workbook

Private workSheet As WorkSheet = workBook.WorkSheets.First()



' Create a freeze pane starting from column E (5th column) and row 5 (5th row).

' The scrolling will begin from column E (5th column) and row 5 (5th row),

' effectively freezing rows above and columns to the left of this cell.

workSheet.CreateFreezePane(5, 5, 6, 7)



' Save the modified workbook to a new file

workBook.SaveAs("createFreezePanes.xlsx")