Copy formula from one excel to another

Help Studio
, ,
1

Hi there,

I’m trying to copy a range of formula from one excel to another using Read Range on the first excel and Append Range onto the second excel. The outcome was the write range seem to write the value rather than the formula. I cannot use “Read Cell Formula” because i needed to fill-in a Data Table into the Append Range instead of just values.Below are the excel and xaml files that i’m currently using.

formula_from.xlsx (10.8 KB)
formula_to.xlsx (10.5 KB)
Copy & Paste Formula.xaml (8.2 KB)

2

Try this:

Copy & Paste Formula.xaml (10,3 Ko)