Append only current row (in for each row activity) to Excel

[rrvdw (Robert)]

Dear all,

I need to append the current dataRow in a for each row activity to an Excel sheet. How do I do this, as the append range activity needs a DataTable instead of a DataRow.

Sincerely,
Robert

[MAHESH1 (MAHESHKUMAR JV)]

@rrvdw

Use ImportRow activity to copy the row to the DataTable which you got by reading the excel sheet.

Make sure that the schema of DataRow is same as the DataTable to which you are copying.

Regards,
Mahesh

[rrvdw (Robert)]

Dear @MAHESH1,

I cannot find import row activity…

Below an example of how I want to have it.

[AshwinS2 (Ashwin S)]

hi @rrvdw
Check this

For each row of datatable, append new row value

Hello, I have a data table that I need to add values to. Essentially, I have a DT like this: ID, City, State AAA, LA, CA BBB, NYC, NY CCC, SD, CA What I need to do is generate a value based on other variables, and add those values as a fourth column to the datatable. I’m assuming I create a new column, but then I don’t know how to append the values to their specific rows. Any help is greatly appreciated!

use Add data row and try to append the data in the excel

Thanks
Ashwin S

[MAHESH1 (MAHESHKUMAR JV)]

@rrvdw
There is no Import Row Activity, That is a method.
You have to do it by using Invoke Method activity.

Regards,
Mahesh