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. [image] How to Set Column width in Excel Help Hello @iumerparay , After writing data in excel, you wan…

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

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%.

Hi can u try balareva activity for this ?

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

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. [Screenshot (67)]

@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. [image] If you still get an error then share the vba code you are using

Hi @Pravin_Patil1 , can you try this? [image] BalaReva.Excel.Activities Continue Help 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.…

Set Column width in Excel

Help Activities

NIVED_NAMBIAR (NIVED N) April 6, 2021, 12:19pm 6

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

Topic		Replies	Views
Change excel column width using VB invoke code Help excel	6	5835	September 22, 2019
AutoFit Column in Excel Studio uiautomation	3	963	July 22, 2022
How to Set Column width in Excel Help excel , activities , question	13	13876	November 7, 2019
How to increase the width of a cell in excel? Help excel , activities , question	4	3375	December 30, 2019
Adjust excel cell width Help	5	10672	March 12, 2017

Set Column width in Excel

Related topics