How to change cell format as text using UiPath or excel formula

Hi Team,

I have one excel and I want to chage the cell format general to text using UiPath or excel formals like vlooup or hlookup

Kindly suggest…
Please find the input and output exce

Thanks

HI @Baby123

You can check the video link

Regards
Gokul

1 Like

Another Method @Baby123

You can also try with Format cell activity

Check out the the Tutorial

Range -> Excel.Sheet("Sheet1").Range("A1")

image

Regards
Gokul

Hi @Gokul001 ,

I want to change entire column at a time .
Is their any excel formula to change the format.

Please suggest

This both the method will change the entire column @Baby123

Hi @Gokul001 ,

Thank You,
But I don’t know knowledge on modern activities
So, can you please send the workflow.

Thanks in advance

Hi @Baby123

Go to → Activities Panel → Click on Filter → Select Show Modern.

image

Step 1 : Use Excel process scope followed by Use Excel file activities.

Step 2 : Use Format Cell Activity,

Check out the XAML file

FormatCellStudioX.xaml (8.5 KB)

Regards
Gokul

Hi @Gokul001 ,

I saw the workflow but after changing the format I want triangle shape in the left corner of the cell .

Please find the attachment below.

.

After changing the cell format as text I want to triangle shape also in each cell

@Baby123

Here one option is to use the Format cell activity. Another approach is , if your template is static, then you can create a Sample Excel Template with all the custom formats for each columns.

Then you can use Read range and write range to that particular template. I hope it can preserve the formats as required.

Thanks