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
Filter according to condition
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 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