How do I change row height in Excel sheet?

[afalciola (Aracely Falciola)]

I do not want the rows to be AutoFit because they go extremely wide. I need row height = 15.

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Hi @afalciola
Welcome to UiPath Community
You could use autofit range modern excel activity

Autofit Range

[Anil_G (Anil Gorthi)]

@afalciola

You can try using invoke vba with this

Function ChangeHeight(str as String, RowPosition As Long, dblHeight As Double)
    ThisWorkbook.Worksheets(str).Rows(RowPosition).RowHeight = dblHeight
End function

Cheers

[afalciola (Aracely Falciola)]

Is there a way to set the row height to 15 using this Autofit Range?

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

No, you can’t do that using the auto-fit range activity. But below post would be useful

Adjust excel cell width

Hi, thanks for the prompt reply. I need to manually set a fix width and height for each column. Is there a way to record adjusting column width and height ?

[afalciola (Aracely Falciola)]

ok, I found easier way to do this using an Excel template with all formats needed including row height desire.
Use this template to plop (copy/paste) data table For Each Sheet and it works!