How to apply freez part in Excel File in particular rows and columns by using Ui Path studio

Help Studio
, ,
1

How to apply freez part in Excel File in particular rows and columns by using Ui Path studio.

2

@raghav.bhardwaj.external

Save the vba into text or .vba and Use invoke vba with this

Sub Freeze_Panes(givenrange As String)

'first, ensure that no panes are frozen

ActiveWindow.FreezePanes = False

'select the row that you want to freeze based on

Rows(givenrange).select

'freeze panes

ActiveWindow.FreezePanes = True

End Sub

Given range is what you need to pass the range where you wnat to freeze

Cheers