Set Column width in Excel

[abhilashreddyalla]

Hi All,

I am working on a project where i need to adjust columns width based on data present. So, I also implemented below solution which is working without any issues.

How to Set Column width in Excel

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. [image]

Now the problem with this is VBA code is, In VM1 it’s working properly and in VM2 the script is not perfectly adjusting column width. Attaching sample output file generated by VM2.
I have tried using macros also, and i didn’t see any improvement and getting same output file as VBA script in VM2. Please let me know if you identified any issue or solution.

Test file.xlsx (34.3 KB)

[NIVED_NAMBIAR (NIVED N)]

Hi @abhilashreddyalla
did any error is thrown while implementing in the VM2?

[abhilashreddyalla]

Hi @NIVED_NAMBIAR

No, it’s not throwing any error. Both the VBA script & Macro are executing in VM2 and they are not adjusting columns width to 100%.

[NIVED_NAMBIAR (NIVED N)]

Hi can u try balareva activity for this ?

[abhilashreddyalla]

Due to restrictions, I am not supposed to install other than UiPath official packages.

[NIVED_NAMBIAR (NIVED N)]

Hi @abhilashreddyalla
Can u try below code in invoke code activity [vb.net ]
[Solved] How can I increase the row height of excel row from vb.net code? - CodeProject

[abhilashreddyalla]

Hi @NIVED_NAMBIAR

In my case the column width shouldn’t be a fixed size. It need to adjust based on data available.

I have tried your suggestion and getting below error at Invoke code activity.

[Pravin_Patil1 (Pravin Patil)]

@abhilashreddyalla

Which column in the attached file do you want to adjust the width?
Also, add some data in excel to see the effect.

Save the vba file with .vbs extension

Make sure you have the below settings enabled.

If you still get an error then share the vba code you are using

[balupad14 (Balamurugan)]

Hi @Pravin_Patil1 ,

can you try this?

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…

Thank you
Balamurugan.S

[Achiranga (Achiranga Gunasekara)]