How to add row values in existing datatable

[thima (Himabindu)]

Hi All,

I have a data table has 3 columns 2 columns have data i want to add values to 3 rd column in for each row loop how to do that? Write cell is taking long time is there any other way.

Regards,
Hima

[Gokul001 (Gokul Balaji)]

Hi @thima

You can use Add data row activity and Append Range activity

Check out this video link and thread

How to Append file excel

If I want combine all file excel in folder in one file. Please guide me.

How to use UiPath Append Range with Excel Example

Regards
Gokul

[Yoichi]

Hi,

Hope the following sample helps you.

ForEchRow case :

LINQ case:

dt = dt.AsEnumerable.Select(Function(r) dt.Clone.LoadDataRow({r(0),r(1),Now.Millisecond},False)).CopyToDataTable()

Sample20221129-1aL.zip (8.5 KB)

Regards,