I am trying to insert concatenate Formula in Excel file in A Column from 2nd row till last used row. I am able to insert the formula but it is not incrementing. So can anyone please help me to fix this.
I used Invoke Code option
Failed_Filtered_Remark.AsEnumerable().ToList().ForEach(Sub(row) row(“Remark”)= “=B2&D2&E2”)
I want to know how to increment this.
Below is excel screen shot.
Hi @nilesh.mahajan ,
instead of using invoke code you can use a write cell activity where you want the formula and then use autofill activity provide the range in it. It will drag the formula
thnx for solution, Is there any way that I can use without Excel Application scope?
Using autofill is a simpler way, if you cannot use that use a for each loop and inside that use a write cell activity and dynamically you can write the formulas