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.
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