Converting the Column to text

Help
1

Hi All,

In an excel, i need to convert column
image

Is there any expression, to change with a single attempt.

2

@sudhasagar I guess you need to just change the Datatype of the Column, After Reading the Excel File, Can you give a Try on using Datatable Change Column type Activity.

1 Like
3

Refer this :
test.xlsx (6.0 KB) Main.xaml (11.5 KB)

1 Like
4

@supermanPunch
What u said, i tried. Still it is not accurate
image

5

@ImPratham45
There are few missing packages in workflow
Can u say what era those, so i can install those packages

image
image748×481 16.2 KB

6

@sudhasagar Can you try using Read Range in Excel Application Scope and after Reading the File , Just Write the Datatable to Another Sheet and Check if it gets Converted. I tried with a sample and it got Converted .

1 Like
7

I’ll try

1 Like
8

I am just using send hotkey activity