Center align

[Parul_Bucha]

How to do center align of any particular column in data table

[balupad14 (Balamurugan)]

Hi @Parul_Bucha,

Welcome to UiPath Community !

Can you please elaborate it

Regards
Balamurugan.S

[Caithlyn_Saturos]

Hi @balupad14

Is there any activity that could align the range of cell in uipath to align the text to center align?

[balupad14 (Balamurugan)]

Hi @Caithlyn_Saturos,

Yes . you have an activity called “Format cells”

UiPathGo - BalaReva Excel Activities

Hi, I have problem with activity “Format Cells” when I want to set vertical alignment of cell(s) to “Top”: [image] I get error message: “Format Cells: Unable to set the HorizontalAlignment property of the Range class” But I do not set Horizontal Alignment at all (I leave “Horizontal” field as “Select”) When I set “Verticle” to “Center”, I get centered horizontal alignemnt, not vertical one. Thanks in advance for help Jerzy P.S. I got this error for version 2019.10.1 as well for 2020.0.1.…

Thank you
Balamurugan.S

[Rajesh_Ramu]

Hi Bala,

I am using the format cell activity, and when I try to give the cell Range, I am getting the attached error.

[balupad14 (Balamurugan)]

Hi @Rajesh_Ramu ,

it is a array . you have to give like below.

Regards
Balamurugan.S