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

[Baby123 (Baby)]

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 excel files below for your reference.

Thanks

[Gokul001 (Gokul Balaji)]

HI @Baby123

You can check the video link

UiPathGo - BalaReva Excel Activities

Hi , In the release Version 2019.2.0. I have added a new activity called Change Cell Type. It changes the format of the value like below. [image] In the Cell Format , can specify the custom format what we have in the excel Like below image. [image] Sample : UiPathGoExcel.zip (18.4 KB) This is the video to configure the package in local. Here is the link to know about the formats. Regards Balamurugan.S

UiPath | How to change the cell or column format in Excel | Guide (datatype)

Regards
Gokul

[Gokul001 (Gokul Balaji)]

Another Method @Baby123

You can also try with Format cell activity

Check out the the Tutorial

[Part 1] Modern Activities - Find/Replace Value | Format Cells

Hello Everyone, Hope you are doing good I would like to present this post who are looking for the Modern Activities Very first thing is to Enable the Modern experience (from Classic) Go to → Activities Panel → Click on Filter → Select Show Modern. [image] Let Jump into the Tutorial we are look into some Modern activities Find/Replace Value Format Cells Note : We need to use Excel Process Scope and Use Excel File for all the above activities Excel Process scope Use Excel File …

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

Regards
Gokul

[Baby123 (Baby)]

Hi @Gokul001 ,

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

Please suggest

[Gokul001 (Gokul Balaji)]

@Baby123

I want to change entire column at a time

This both the method will change the entire column @Baby123

[Baby123 (Baby)]

Hi @Gokul001 ,

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

Thanks in advance

[Gokul001 (Gokul Balaji)]

Hi @Baby123

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

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

[Baby123 (Baby)]

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

[Rahul_Unnikrishnan]

@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