I tried the " UiPath.Excel.Activities.ExcelCopyPasteRange " Activity to do this but it only allows copying a range (or multiple cells) and paste it into a range of the same size.
U can try read cell activitiy to read a cell and then use write range to write the cell
That will not work because the value of the cell has leading 0s in text format and when I use write cell or write range this activities deletes those ceros
I did this way
Here the input file used is
Output is got
Two things mostly i had done is
the data obtained from read cell is store in output variable which is generic Value datatype.
Also checked the preserve format in read cell activity
Check this workflow
Main.xaml (6.4 KB)