Copy data from excel without formula

Help
, ,
1

Hi All,

I have a scenario where i have to copy data from one excel to another , i tried using read and write range activities but along with data formula is also copied (i.e in every cell -2146826246 value is pasted) please suggest how to handle it.

2

Hi
Welcome to uipath community
do you mean like you want to copy along with formula
Cheers @rpatil

3

Hi ,

No i just want to copy data i do not need formula

4

@Palaniyappan

1 Like
5

Awesome
Then normal READ RANGE and WRITE RANGE activity would work
that is the sequence would be like
–use excel application scope and pass the file path of first excel as input and
inside the scope use READ RANGE activity and get the output with a variable of type datatable named dt
–now use another excel application scope and pass the filepath of second excel as input
and inside this scope use WRITE RANGE activity and mention the datatable dt as input and enable ADD HEADERS property

Cheers @rpatil

6

I had tried the same as about but still all cells is filled with value -2146826246
@Palaniyappan

7

image
image716×508 7.87 KB

date column is correct but rest i am getting error . The file i am copying data from is macro-enabled @Palaniyappan

8

hmm fine
can i have a view on the actual file with a screenshot
@rpatil

10

@Palaniyappan any solution?

11

Would it be possible for you to send a sample excel file? the process rpatil suggested should work.

Thanks,
Anshul

12

hi @rpatil,

There is an option of preserve format in Read range you can try .But Mind you , this Slows the Processing,

image

–
Mukesh