Copy and paste more values simultaneously in one go

excel

#1

Dear UiPath Community

In my current application I am using a for each loop to read a cell from an excel file and paste the content to another Excel file. I use the same variable because it gets updated in the loop.

Is there a way to read all of the values from the first Excel file, store them in n variables, in order to then paste the whole array of values in the new Excel in “one go”? I am trying in this way to speed the process up.

Thanks

Kind regards

Gennaro


#2

Why not use the excel activities for this?

If at all you want to copy/paste, you could write your values to List and add below to Set to Clipboard

String.Join(Environment.Newline,varList) --> Paste Column

String.Join("\t",varList) --> Paste Row
or
String.Join(Convert.ToChar(9),varList)


#3

Thanks!

But where should I write that script? On which activity? I’m new to it!

Thanks

Kind regards

Gennaro


#4

Set to Clipboard Activity.


#5

you can use “clipboard activity” in activity panel