TRYING TO ADJUST THE WIDTH OF MY EXCEL

Help Studio
1

I am using a UiPath 2020 version and I am unable to adjust the width of my excel sheet . is there any options . thanks

2

Hi,

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)

image

Regards,

3

@mma

You can use a macro or vba as below

Sub(sht As String,Rng As String)

ActiveWorkbook.Sheets(sht).Range(Rng).EntireColumn.AutoFit

End Sub

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

End Sub

Here range call be a single cell in the required column

Cheers

4

I dont have that installed, do you have another way

5

Hi,

Is there StudioX option in the following filter? And can you upgrade your UiPath.Excel.Activites package to the latest?

image

Regards,

6

I Dont have the studio x , Also I have the latest version. Any other suggestions

7

any way to change the width on the excel sheet

8

Hi,

We can use StudioX activities in Studio.

Regards,

9

still not working for me ,