Barry John Edwards May 24, 2016 12:23 ANSWERED Hi, I am writing an automation where two excel spreadsheet worksheets are compared. If a row in Sheet 1 is not in Sheet 2 then the row is added to sheet 3. However, I get the following exception when I try it:- Add data row : This row already bel…

Hello, The issue you are having with “Add data row : This row already belongs to another table.” can be solved by passing row.ItemArray from initial row and pass it to the ArrayRow property of the Add Data Row Activity. I would also consider the Merge data table activity which can be useful somet…

Copy Row from one DataTable to another

Help

UiRobot (UiPath Robot) October 21, 2016, 1:44pm 2

Andrzej.Kniola May 24, 2016 16:23
Hi,

Easiest (as in - least code) way I’m using is InvokeMethod instead of AddRow.

This is the InvokeMethod part (can’t attach xaml files, so…) :

[dt2] [row]

From a screenshot it looks like this (Parameters can be opened from InvokeMethod’s properties pane on the right):

17 Likes

How to read 1 row or multiple rows from one excel sheet and write it in another excel sheet

Get row under current row in datatable/excel

Topic		Replies	Views
Multiple databtables, add data row is not co-operating Help datatable , activities , studio	20	2630	May 19, 2019
Column 'XXXX' already belongs to another DataTable Help	11	13612	October 29, 2018
Add Data Row throws exception when you try to add DataRow from table 1 to table 2 Help	5	2437	November 20, 2018
DataRow property in AddDataRow activity Help studio	4	4372	April 12, 2019
This row already belongs to another table error while copying the row from one data table to another Help activities , studio	2	6157	December 31, 2018

Copy Row from one DataTable to another

Related topics