I have certain data in a datatable . I want to paste those data into the Excel sheet and apply formulas to the newly added data.
Assume I have data from column A to E in a Datatble. Now am using write range with the help of row count am writing data.
Next from column F to K columns–>each row has formula ,iNow copy formula from E1 using copy formula activity
Now how to apply those formulas against newly added data ?? and also row number should change dynamically