How expand the rows and column in excel

Help Activities
,
1

Hi every experts

i would like to expand all the rows and columns in my created excel sheet. The header of the file were wrap text and whenever UiPath copy and paste from a datatable. The result will look like Fig 1 and i would like to automate it to follow like Fig 2.

the below is the picture of illustration

From Fig 1

image
image414×807 8.63 KB

To Fig 2

image

2

Hi,
You can use the ‘Auto Fit Range’ activity in excel activities to adjust the column and row width. Please see the details in the below link:https://docs.uipath.com/activities/other/latest/user-guide/auto-fit-x