How can I AutoFit columns with oficial packages in UiPath?

[ahmadLH]

AutoFit all some columns of some sheets

[prasath17 (Guru)]

@ahmadLH … on the activities Menu there is a filter menu…Choose StudioX…as shown below

Then Choose Autofit activity …

.

This activity needs to inside the “Use excel file” and have to be used as shown below…

[ahmadLH]

I don’t have AutoFit

[prasath17 (Guru)]

@ahmadLH - What UiPath and Excel activity version you are using??

[ahmadLH]

UiPath Studio 2020.4.1 and Excel Activities 2.9.5

[prasath17 (Guru)]

@ahmadLH - Under the Manage Package see you have Preview available?

[prasath17 (Guru)]

@ahmadLH - If this Route is not working…Then you have to use Send HotKey/Keyboard Shortcuts activities to send the Keyboard shortcuts to excel for Autofit.

[ahmadLH]

It seems like is gonna work thanks a lot!

[prasath17 (Guru)]

@ahmadLH - Let me know, whether you able to achieve it via keyboard shortcuts?..I just tried and it worked.