Output of my excel should look like this

Help Studio
, ,
1

I want this type of output in my excel using uipath

image
image1152Ă—864 206 KB

2

Hi,

Please give the idea about your scenario, Please provide what is Input and what will be the Output.

Regards,
Prathamesh

3

The output will be my above image
And my input looks like this

IMG_20201204_091352
IMG_20201204_0913522304Ă—1728 1.8 MB

Can you assist me in this scenario
Regards,
Puruahothaman

4

Hi you just want to Format it?

5

How to do formatting because I am new to this rpa
Regards,
Puruahothaman

6

You can use VBA (Macro) For this

7

Use “SetRangeColor” Activity to colour your rows. For this specific format you might have to use SetRangeColor in a for each loop to colour every row.

8

Hi @Purushothaman_S,

Try this ConvertVB.zip (347.9 KB)

in in_filepath argument pass your file path.

Mark it solution if it works.

Cheers!

1 Like