FreezePanes
Locks specific rows and/or columns in an Excel worksheet so they remain visible while a user scrolls through the rest of the data. This feature enhances readability and is used for header rows or important reference columns in large datasets.
Input
| Name | Type | Description |
| File | String | The full path to the Excel workbook file where the freeze operation will be performed. This should include the file name and extension, such as C:\Reports\SalesData.xlsx. |
| Sheet | String | The name of the worksheet within the specified Excel file where the freeze panes operation will take place. The name must match an existing worksheet in the workbook.
The default value is sheet1. |
| Freezeposition | String | Specifies the top-left cell that defines the freeze panes region. All rows above and columns to the left of this cell will remain visible when scrolling. To remove any existing freeze, set this value to 'UnFreeze'. |
Result Set Columns
| Name | Type | Description |
| Result | String | Returns the status of the operation, indicating whether the freeze panes action was successfully applied or if it failed during execution. |