Change format HEADER in excel without VBA

Soudios · September 24, 2021, 10:10am

How can i change the format header

from :

To this :

Charbel1 · September 24, 2021, 2:27pm

What’s the problem with VBA?

Soudios · September 24, 2021, 2:30pm

In this case i can’t use it

Charbel1 · September 24, 2021, 2:34pm

Okay, fine.

You can find a Format Cells activity in BalaReva.Excel.Activities package.

and these are the properties that you should modify:

P.S: Wrap Cells should also be modified to True.

Best,
Charbel

Soudios · October 1, 2021, 4:22pm

It change but the text does’t reconize by the filter

Charbel1 · October 2, 2021, 7:31am

Can you elaborate more please? (Or send some screenshots of what you mean)

Palaniyappan · October 2, 2021, 8:55am

Hi

Pls refer this video on how to do the format change with UiPath CUSTOM ACTIVITY by Balareva

Topic		Replies	Views
How to change cell format as text using UiPath or excel formula Activities excel , activities , studio	8	2344	October 26, 2022
Can i change an Excel cell format without VBA plz? Studio excel , activities , question	2	2081	March 20, 2020
Change format for a column in excel Studio	1	1013	November 10, 2021
How to Change the particular Column Cell format from general to Number format using uipath Activities excel , activities , question	5	748	February 7, 2022
Change excel data format Studio studio , question , activities_panel	2	1018	February 1, 2022