How to move Information excel to excel

I want to know how to move excel data to another excel.
Please let me know.
Thank you.

As the picture below.

1 Like

Fine
Hope these steps would help you resolve this

—use excel application scope and pass the file path of input excel
—inside the scope use a read range and get the output with a variable of type datatable named dt
—now next to this excel application scope use a Build datatable activity and create a datatable with columns we want to have in our final excel
And get the output with a variable of type datatable named Finaldt
—now use a for each row loop and pass the variable dt as input
—inside the loop we can use ADD DATAROW activity where we can mention the datatable in property panel as Finaldt and in the ARRAYROW property mention the values in a array format like this
{row(0).Tostring,row(1).ToString,…,row(n).Tostting}

Where 0,1,2 are the column index that will take the value from dt and assign it to Finaldt datatable

Make sure that the number of values in this array should be equal to the number of columns in the Finaldt

—then finally use a write range activity from workbook activities and mention the excel path we’re we need to write and datatble as Finaldt and enable the add headers property as well

Cheers @BoBou_JunG

@BoBou_JunG

You can use Merge datatable or append range activity or write range based on your condition.

  1. If columns name are equal use merge datatable
  2. If you need to paste on the from A1 then use Append Range.
  3. If you need write in Secfic range then use write Range by getting the last row of main excel.

thanks,
Suresh J

Thank you so much :slightly_smiling_face:

Thank you so much. :slightly_smiling_face:

1 Like

Kindly try this and let know for any queries or clarification
Cheers @BoBou_JunG