This article explains how to set freeze panes in Excel using C#/VB.NET.
How to set freeze panes in Excel?
Rows and columns can be frozen using IRange.FreezePanes() method. To freeze the rows or columns one must call the freeze panes by the range with next column and row.
For example, when we need to freeze first row we need to select range “A2”. If we select range “B2”, then the first row and first column will be freeze in worksheet. So, we need to select the range next to the range that needs to be frozen.
To set a freeze pane, you need to follow the below steps.
Steps to set freeze panes
The following C#/VB.NET complete code snippet shows how to set freeze panes in Excel using XlsIO.
The following screenshot shows the output Excel document with freeze panes generated using XlsIO.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|