How to Set Column width in Excel

[iumerparay (Umer)]

Hi

How to set column width in excel , After i run my activity my log is displayed , But in the format with no width column set How do i get the displayed log files with proper width set columns.

[Rocki_Jan]

Any reason why you need to set Width and height of column?

[sarathi125 (Parthasarathi)]

@iumerparay

use it, it is from Excel.Extensions Package, you need to add this package to work with.

[iumerparay (Umer)]

how do i set the column width height row here

[iumerparay (Umer)]

so that it always displays in a sequence order.

[Rocki_Jan]

You can pass any integer value and test it.

[sarathi125 (Parthasarathi)]

Mention some pixel value, ex: 120. Then try, else get value from excel and set it here

[Rocki_Jan]

@iumerparay

so that it always displays in a sequence order.

How will setting column width will help here? If it is for attended, then it makes sense.

[sarathi125 (Parthasarathi)]

Mention some pixel value, ex: 120. Then try, else get value from excel and set it here.

You need to use select range for that column and then use this activity

[iumerparay (Umer)]

as i run the activity, log is generated in background, what i am trying to say is it should come in the same format with proper column width after the activity is stopped and log is generated. And even if i use Excel.Extensions Package i have to use it in excel extension scope.

[sarathi125 (Parthasarathi)]

@iumerparay,

Check this xaml, it is working, it increased all the column width to the value mentioned.

SetExcelColumnWidth.xaml (5.8 KB)

[samir (Samir Mohite)]

Hello @iumerparay,

After writing data in excel, you want to auto-fit the column right?
Then, using Invoke VBA could be a option.

firstly write the code below in txt file.

Sub ColumnWidth()
Columns("H:H").EntireColumn.AutoFit
End Sub

Then use Invoke VBA activity in excel application scope and mention txt path and methodName e.g here i’ve used ColumnWidth just change column in above code as here’s H.

[allurai_india ((Allu)Alluraiah Yallapragada)]

can you try with shortcut Alt+O+C+A

[balupad14 (Balamurugan)]

Hi @iumerparay

Here is some activities to set width height for column and rows.
1.AutoFitColumn.
2.AutoFitRow.

It has an option to specify the width and height.

BalaReva.Excel.Activities Continue

Hi Friends, I have included some new activity in the package (AutoFitColumns,AutoFitRows,Format Cells). Now you can get the package here. I have uploaded the package in the UiPath Go. After It is uploaded , I will remove the package from here. Namespace : [image] AutoFitColumns Properties : [image] Usage of Column Range Single Column = { “A:A” } Continuous Columns={“B:D”} Multiple Columns ={ “A:A”,“D:D”, “E:G” } Range of Cells ={“A1:D8”} To set column width AutoFit=False ColumnWi…

Regards
Balamurugan.S