Excel Application Scope - Append range activity overwrites the last row data. Suppose I am using write range activity to write the datatable from row “A2” having 10 rows and after I am using append range activity to write the same datatable but it overwrites the last row of the previous data and making the data incorrect.
What did I want in the result?
I want 20 rows in the output but giving me only 19 rows.
Note: If I am writing the data from the row “Ä2” then the result is incorrect on the other hand if I am writing the data from “A1” the output data is correct