How to autofit columns in Excel document

[Vikram212 (Vikky)]

hi
can anyone suggest how to autofit columns while working with MSexcel file using uipath.

TIA

[chandu4712 (Chandan)]

can you please elaborate your question more.
Auto fit in what way?

[balupad14 (Balamurugan)]

Hi @Vikram212,

You need to set particular column autofit or all columns.

Regards
Balamurugan.S

[Vikram212 (Vikky)]

Hi @balupad14
i need to set particular columns where data will be existing

[balupad14 (Balamurugan)]

Hi @Vikram212,

Take the package in the below link.

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

[Vikram212 (Vikky)]

Thanks Bala @balupad14
Much appreciated !