SSIS Components for Microsoft Excel

Build 24.0.8963

FreezePanes

Keep rows and columns visible while the rest of the worksheet scrolls

Input

Name Type Description
File String The file path to the Excel file.
Sheet String The name of the Excel worksheet inside the workbook.

The default value is sheet1.

Freezeposition String Need to specify the cell, and the left and top of the cell will be frozen. Also set to 'UnFreeze' to unfreeze

Result Set Columns

Name Type Description
Result String The freeze succeeds or fails.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963