Syncfusion.XlsIO.Base
Example 


FreezePanes Method

Keep rows and columns visible in the Range while the rest of the worksheet scrolls.
Syntax
'Declaration
 
Sub FreezePanes() 
'Usage
 
Dim instance As IRange
 
instance.FreezePanes()
void FreezePanes()
Example
The following code illustrates how to freeze a pane in the Range.
ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
application.DefaultVersion = ExcelVersion.Excel2013;
IWorkbook workbook = application.Workbooks.Create(1);
IWorksheet sheet = workbook.Worksheets[0];
            
//Applying Freeze Pane to the sheet by specifying a cell.
sheet.Range["B2"].FreezePanes();
            
workbook.SaveAs("Freeze.xlsx");
workbook.Close();
excelEngine.Dispose();
AssemblyVersion

Syncfusion.XlsIO.Base: 16.4460.0.40

See Also