Autofit column in a excel sheet

[MaxyArthes]

Hello, is there any ways in UiPath to autofit every column of a Excel?

The problem I got right now is that I read a Excel using “Preserve format” so if the column is too small, the text get replaced by “#####” and I can’t get the real text.

I tried with the librarie “BalaReva.Excel.Activities” but the autofit method don’t seems to exist anymore.

[nerlichman (Nicolas Erlichman)]

I’ve done it by writing a macro that does that, and then use Invoke VBA activity to run that macro.

For the macro itself you could take a look at Range.AutoFit method.

[sarathi125 (Parthasarathi)]

@MaxyArthes,

You can try with UiPathTeam.Excel.Extensions.Activities, it has autofit option for a column.

https://go.uipath.com/component/excel-extension-activities

[Jan_Brian_Despi]

@balupad14

@MaxyArthes

I tried with the librarie “BalaReva.Excel.Activities” but the autofit method don’t seems to exist anymore.

[sarathi125 (Parthasarathi)]

@MaxyArthes, @Jan_Brian_Despi,

Check this one, it is working.

[balupad14 (Balamurugan)]

Hi,

I have updated the information for Autofit Column and Row with properties here.

UiPathGo - BalaReva Excel Activities

Hi, Here is the information about the Autofit column and row… you can get the package like below in the studio. [image] The activities are : [image] Properties [image] Here you have an option to specify the Column Width instead of AutoFit [image] Here you have an option to specify the Row Height instead of AutoFit Thank you Balamurugan.S

Thank you @MaxyArthes and @Jan_Brian_Despi

Regards
Balamurugan.S

[MaxyArthes]

What I did as I was unable to find any others solutions, but some others has been posted now. Just mentioning it for the next people that gonna see this thread