How to Insert concatenate Formula from Second row till last used cell in Column

Help Studio
1

Hello,

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.
image

Below is excel screen shot.
image

2

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

3

Hi @nilesh.mahajan ,

here is a example

image

4

Hello,
thnx for solution, Is there any way that I can use without Excel Application scope?

5

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