Copy past in value issue

Help Forum
1

I want to copy all the information on sheet 1 to sheet 2 but i only want the value.
With copy past activity it takes the same format from the sheet 1 even when i select only “value”

2

Hi

Hope these steps would you resolve this

—use a excel application scope and pass the file path as input and inside the scope use a read range activity
—Disable Add headers property in read range so that you will get only the value and get the output as dt datatable

—and outside this excel scope use a write range activity from WORKBOOK activities
—search as workbook in activity panel and include write range where mention the file where you want to insert this data
And disable ADD HEADERS and mention dt as input so that it will type only the values withou headers

Cheers @Soudios

1 Like
3

Thank you my friend

1 Like
4

Anytime @Soudios
Have a great day

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.