Resize cell width

[yuppiensimpson (성만 천)]

hi everyone!!
i have one question.
how to adjust the width of a cell by the size of the text of the cell in excel?

[vrdabberu (Varunraj Dabberu)]

@yuppiensimpson

Use the autofit range activity.

Use the excel process scope
within that use the use excel file so that it opens the specific file.
Use the autofit range activity
Use the below syntax within that

Excel.Sheet("SheetName")

Hope it helps!!

[rlgandu (Rajyalakshmi Gandu)]

@yuppiensimpson

To adjust the width of a cell in Excel based on the size of the text in UiPath, you can use the "AutoFit Range " activity. This activity automatically adjusts the width of a specified column to fit the contents of the cells in that column.

[mkankatala (Mahesh Kankatala)]

Hi @yuppiensimpson

You can use the Auto Fit Range activity which uses to adjust the size of the cell based on the length of text in the cell.

Note - You have to use the Auto fit range activity inside the Use excel file activity. You find this activities only in modern design experience.

=> Use excel File activity
→ In Excel file field give the Path of the Excel File.
→ Check the Save Changes option.

=> Auto Fit Range activity
→ In Select a Source option Give the range like this Excel.Sheet(“Sheet Name”)
→ Check the both rows and column option.

Check the below image for better understanding.

Hope it helps!!

[Akshay_B]

hello @yuppiensimpson ,
You can use the Excel activity called “AutoFit Range” for this.
Regards;)

[mkankatala (Mahesh Kankatala)]

Thank you @yuppiensimpson for Make marking as solution.

Happy Automation!!