How to do the special paste in excel sheet

Hello.

I’ve copied all the data from a sheet with "Read Range"activity and using the property in “Read Formating” = Display Value and I have to paste it into a new sheet I’m using “Write Range Workbook” activity…but I’m not sure If I’m doing the kind special of paste that the user needs …

I’m using this structure in the file.xaml


Could you guide me If this process automation is doing the special paste, please?
Thanks.
Main.xaml (16.6 KB)

@pprin001

Idealy yes this does paste the values only…as display value will be reading only the values

The final formatting might be different.as you are pasting only values and no formatting

Cheers

1 Like

Hi, In case you want to do paste with formatting, you can use the UI clicks and paste the range using the Paste Special option.