Copy from one cell to other cell

Help
1

Hi Team,
copy from A2 cell and paste into another excel file
image

Here A2 is not just a number, if i copy and paste from read cell activity to write cell activity
it will take as 01 and paste it as 1, i need 01…So we have to use excel formula like “=TEXT(A”+CellCounter.ToString +“,dt)”

Here i taken CellCounter as variable as stored as 2 default and dt is read cell value…But it is not working…Please help me on this

1 Like
2

Can You Try in Write Cell Activity as '01

3

i used write cell activity only, but it is taking as 1,

So i tried with formula…but that also not working

4

append ’ before your Value in Write Cell Activity

5

That also i tried, its not working

6

In the write cell, have to do format the cell from number to text…then only it is pasting as 01

7

Check the sample Workflow it worked for me though

Sequence5.xaml (6.9 KB)

8

That whats am saying, while copying it will copy as 01 and while pasting it will do as 1

9

its not number, its text
image

10

This will surely work have tested it as well .
it will take value from Sheet1 and paste it in sheet2.
Check if u have enabled preserve format

Desktop.zip (8.2 KB)

11

Hi,

when i write, am facing like this in the excel sheet,

am not getting as 01, am getting as '01 in the excel.

Please help me

image

12

Hi @Sharanabasava,

Please check it here the solution.

Regards
Balamurugan.S