Paste Datarow into excel

Hello, i’m having a problem to paste a datarow into an Excel.
I’m having a datatable with 3 columns and 20 rows. I want to paste a datarow after a row where column 1 has value “value1”.
So when value 1 on column1 is standing on row 7, i have to put a new row under row 7 with my datarow. Does someone has an example of this?

Hi @hansgeeroms,

This is can be done with filter data table activity here -

Read excel

image

Filter according to condition

image

Main.xaml (11.4 KB)
result.xlsx (8.4 KB)
Test.xlsx (8.9 KB)

Let me know if this is what you are looking for.

Thanks,
Prankur

Hi @hansgeeroms

Try this.

AddDataRowToSpecificIndex.zip (9.1 KB)

Let me know if this helped.

Hi Sid, This is what i need, but i need to do it with Variables.
Then i got error when i want to execute it.

In my first invoke i need something like this then:
drRow(0)=strName
drRow(1)=strPrename
drRow(2)=strYear

When i do this i got this message:
‘variable’ is not declared. It may be inaccessible due to its protection level

Did you add these variables as arguments in the “invoke code” activity? If not, try that, and it should work.

Thanks Sid, it works!

1 Like