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

[T_Y_Raju]

How to Convert Excel Columns to Text Format using uipath

[brunabruno (Bruna Cavalcanti Bruno)]

Hello @T_Y_Raju,

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:

How to Convert Excel Columns to Text Format using UiPath

Hi, This will convert the column to String format i.e. it will be ‘General’ in Excel I want the column to be ‘text’ format in excel.

Regards,

Bruna Bruno.

[jack.chan]

@T_Y_Raju
download this component

Excel Activities for Processing and Filtering - RPA Component | UiPath...

then use this activity

[Sudharsan_Ka]

Hi @T_Y_Raju

You can use change cell type activity

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

Or you can use modern activities format cells

[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 …

Regards
Sudharsan

[Gokul001 (Gokul Balaji)]

Hi @T_Y_Raju

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

1. Use Excel Process Scope

2. Use Excel File → Give the Input Excel path

3. Use Format Cell activity

Source : Excel.Sheet("Sheet1").Range("A1")

Format data as Type | Set Format

Data Type: Text

Regards
Gokul

[T_Y_Raju]

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