How to Convert Excel Column from general to Text Format using uipath

How to Convert Excel Columns to Text Format using uipath

Hello @T_Y_Raju, :smiley:

You can use the formula =TEXT(value you want to format; “Format code you want to apply”). Look my example:

Example.xaml (8.2 KB)

Or, the discussion below can help you too:

Regards,

Bruna Bruno.

@T_Y_Raju
download this component

then use this activity

Hi @T_Y_Raju

You can use change cell type activity

Or you can use modern activities format cells

Regards
Sudharsan

1 Like

Hi @T_Y_Raju

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

image

  1. Use Excel Process Scope

  2. Use Excel File → Give the Input Excel path

image

  1. Use Format Cell activity
Source : Excel.Sheet("Sheet1").Range("A1")

Format data as Type | Set Format

Data Type: Text

image

Regards
Gokul

can u send me this code with screenshot, Iam not able to open the XAML file my studio version is 19.10.6