Syncfusion AI Assistant

How can I help you?

How to unfreeze the rows and columns in XlsIO?

27 Mar 20262 minutes to read

You can unfreeze rows and columns in XlsIO by using the RemovePanes method. The following code snippet illustrates this.

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  IWorkbook workbook = application.Workbooks.Open("Sample.xlsx", ExcelOpenType.Automatic);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Freeze the panes
  worksheet.Range[8, 1].FreezePanes();

  //Unfreeze the panes
  worksheet.RemovePanes();

  workbook.SaveAs("Unfreeze.xlsx");
  workbook.Close();
  excelEngine.Dispose();
}
using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Excel2013;
  IWorkbook workbook = application.Workbooks.Open("Sample.xlsx", ExcelOpenType.Automatic);
  IWorksheet worksheet = workbook.Worksheets[0];

  //Freeze the panes
  worksheet.Range[8, 1].FreezePanes();

  //Unfreeze the panes
  worksheet.RemovePanes();

  workbook.SaveAs("Unfreeze.xlsx");
}
Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Excel2013
  Dim workbook As IWorkbook = application.Workbooks.Open("Sample.xlsx", ExcelOpenType.Automatic)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)

  'Freeze the panes
  worksheet.Range(8, 1).FreezePanes()

  'Unfreeze the panes
  worksheet.RemovePanes()

  workbook.SaveAs("Unfreeze.xlsx")
End Using

See Also