I am using a UiPath 2020 version and I am unable to adjust the width of my excel sheet . is there any options . thanks
How about Autofit Range activity? it may be necessary to turn on StudioX at Filter in Activities panel. (And update to the higher version of UiPath.Excel.Activities package)
You can use a macro or vba as below
Sub(sht As String,Rng As String)
Alternately if you want to set a specific width then we can customize as well
Sub(sht As String,Rng As String,wth As String)
ActiveWorkbook.Sheets(sheetName).Range(columnRange).EntireColumn.ColumnWidth = wth
Here range call be a single cell in the required column
I dont have that installed, do you have another way
Is there StudioX option in the following filter? And can you upgrade your UiPath.Excel.Activites package to the latest?
I Dont have the studio x , Also I have the latest version. Any other suggestions
any way to change the width on the excel sheet
We can use StudioX activities in Studio.
still not working for me ,