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


#1

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


#2

@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


#3

Dear @MAHESH1,

I cannot find import row activity…

Below an example of how I want to have it.


#4

hi @rrvdw
Check this

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

Thanks
Ashwin S


#5

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

Regards,
Mahesh