I am sorry if this question was already asked although I’ve searched.
This is probably an elementary excel - uipath question.
I know I should seach for alternative ways than what I wrote below,
but I would like to know if there is a way to realize this.
I would like to paste datatable A to excel A.
Datatable A only has values (doesn’t have formula).
Excel A has formulas.
I would like to keep formulas of Excel A when I paste datatable A over them.
when I tried pasting datatable A I could see Excel A formula disappears.
(Excel A already has old values before pasting datatable A.
I want to replace the values by pasting datatable A but keep the formulas.)
I tried read range and write range but didn’t work.
I also tried select range and send hotkey(paste only text: alt + h + v + t) but didn’t work too.
Thank you for reading.