Unfreeze Rows or Columns

Introduction

In this article, we will learn How to UnFreeze Rows, Columns and Panes. If worksheets in the Excel files are frozen, sometimes we want to unfreeze worksheet or adjust frozen rows, columns or panes.

In Excel

1. Click View tab > Freeze Panes > Unfreeze Panes.

UnFreeze Rows, Columns or Panes with Aspose.Cells for .Net

It’s simple to unfreeze panes with Aspose.Cells for .Net. Please use the Worksheet.UnFreezePanes method to unfeeze panes .

1. Construct Workbook to open the frozen file.
2. Unfreeze panes with Worksheet.UnFreezePanes() method.
3. Save the file.

 // Instantiate a new Workbook.
  Workbook workbook = new Workbook("Frozen.xlsx"); 
//  Unfreeze panes.
  workbook.Worksheets[0].UnFreezePanes(); 
// Saving the file
  workbook.Save("Unfrozen.xlsx");

Attached sample source Excel file.