How to add "Add Data Column" on a existing data table and insert data on new columnm

[roysupriya21 (Supriya Roy)]

hello everyone,

I have inserted an excel where you will see 3 columns(sheet1) account no , credit , debit
now my requirment is:

1. I have to make substraction credit - debit against each account no
2. and then i have to create new column “Net” and paste the substraction value for the each account no

please also check the sheet2 for the requirted output.

please help me with your suggestion.

Thanks in advance.test.xlsx (9.2 KB)

[pravin_calvin (pravin kumar)]

Hi @roysupriya21

Read range the Datatable

Add Datacolumn Actvity and add the Column Net

For Each row in datatable

Assign Current row(“Net”) = cint(CurrentRow(“Credit”).ToString)-Cint("CurrentRow(“Debit”).ToString)

Outside the loop Write Range The datatable

Refer to the xaml below!

testColumn.xaml (6.9 KB)

Regards

[roysupriya21 (Supriya Roy)]

thank you so much…