@Hanno That will be Grate help to OS Community!!!!

Hi @Hanno , we are waiting to have function in component. I hope many others also wanted to have this. So could you please make this function available along with your next update. Thank you!!!!!

Hi @Rohan Hanumante,

Good news — this is already supported, no workarounds needed. Use the Cell_Freeze action from Advanced Excel; it sets Excel's "freeze panes" on the worksheet, so the frozen rows/columns stay sticky when you scroll the downloaded file.

The one thing to know is that the Row/Column you pass is the first cell that should scroll (i.e. the cell just below/right of what you want to keep visible):

• Sticky header row → Cell_Freeze(Worksheet, Row: 2, Column: 1) — row 1 stays pinned.
• Top 2 rows sticky → Cell_Freeze(Worksheet, Row: 3, Column: 1).
• First column sticky → Cell_Freeze(Worksheet, Row: 1, Column: 2).
• Header row and first column → Cell_Freeze(Worksheet, Row: 2, Column: 2).

Flow-wise: select your worksheet (Worksheet_Select), write your data, call Cell_Freeze once, then Workbook_GetBinaryData to download. The freeze is saved into the file, so it's sticky whenever the user opens it.

Just make sure you're on the latest version of the component from the Forge. Hope this helps!