Excel Formula preserve

i want Preserve formula from one excel and drag it for the total number of rows finally present in next excel.
how to preserve the formula from one excel if formula cell is not known?

You can retrieve the formula if the cell is known, that is using VB code not with the activities @Krutika_Kotkar.

For filling the range of data, you can read range of one sheet and get the row count , then you can simply use auto fill range activity which will fill the entire row based on the number of rows you give