How to change the format in exel plz

Help Studio
1

how to change the format in exel plz

3

the cell,

For ex : Change the color / policy / Extend the cell / add filter…

5

Hi

You can check this macro for changing the format and color of the cell

1 Like
6

thank you but i don’t know how to do that (Macro…)

7

Hai @Soudios … Use Set range color activity to change the color of the cell…

2 Likes
8

Refer this
This may help u for add filter

1 Like
9

https://excelcult.com/2019/07/04/how-to-execute-macro-in-uipath/refer this one, this may help u to get the information about macros.

1 Like
10

there is not an other way without macro ?

11

hi @Soudios you can done this with in both VBA and BalaReva.Excel.Activities… for more info about it go through the b’low link,

hpy learning…

1 Like
12

ok i used invoke vba, but

The macro is outside of the Excel file

I need something like that : (Fichier1 = ExtractDatatable)

image
image1434Ă—623 26.7 KB