Once excel row data need to add another excel

Help Studio
, ,
1

I am getting excel and each excel having only single row only in DT!, you can see at given below

image
image820Ă—431 20.4 KB

i need to add the above DT1 row in this below excel DT2 from C column to F Column.

image
image753Ă—321 6.33 KB

Please kindly let me know the logic for this

thank you!!!

2

Hi

Hope the below steps would help u resolve this

  1. Use a READ RANGE WORKBOOK activity and get the output of first excel as a datatable named dt where set the range as ”C1:F2”
  2. Now use another same activity and get the output for second excel as dt2
  3. Then use a Add Datarow activity and mention like this in ArrayRow property
    {string.Empty,string.Empty, dt.Rows(0)(2).ToString, dt.Rows(0)(3).ToString, dt.Rows(0)(4).ToString, dt.Rows(0)(5).ToString}
    And in datatable mention as dt2
  4. Now use a WRITE RANGE workbook activity and mention dt2 as input and enable add headers property

Cheers @vineelag

1 Like
3

can you share me with the xaml

4

I don’t have my laptop aside
But these are pretty straight forward steps
Try to look for these activities
I m pretty sure you will be able to find and build it
@vineelag