How to do the special paste in excel sheet


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?
Main.xaml (16.6 KB)


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

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


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.