Filter and Append data

Help Activities
, , ,
1

HI All,

I have Master excel which contain 80 column .
and Child excel contain 10 column.

i want to append data of child excel (B,C,D,E) column value into (B,c,d,e) column of master sheet. Append is to be done at the top.
So first Child data come and after that Masterdt come.

I cant use excel related activity as office is not installed in VM

2

@TUSHAR_DIWASE

Use insert rows and then use write range…Number of rows is row count of your datatable

cheers

3

Sorry i forgot to mentioned . I cant use excel related activity as office is not installed in VM

4

Follow below steps

  1. Read Range - Mastersheet - DT_Master

  2. Read Range - Childexcel - DT_Child

  3. For Each Row - DT_Master - current row

        Add Data row - 
      Array row - {current row ("B")...., current ("E)}
       Data table - DT_Child

  4. Append Range -Add File Name, Sheet Name, for data table name provide DT_Child

Note : Variable Names can be modified as required

5

@TUSHAR_DIWASE

then read the data

write the new data

then use append

cheers

6
  1. Combine Data Tables:
    *Append the data from the child DataTable to the master DataTable. You can use the Merge Data Table activity or simply use the Add Data Row activity to add rows from the child DataTable to the master DataTable.
  2. Write Data Back to Master Excel File:
    Use the Write Range activity to write the combined data (master DataTable) back to the master Excel file.