COPY EXCEL DATA TO ANOTHER EXCEL

Help Studio
, ,
1

Please Help
I have two excel “Data Grafik” and excel “List account”

How to create a UiPath flow if I want to copy data in excel “Data Grafik” in the “Account” and “AM Name” columns obtained from excel “List Account”?
Data Grafik.xlsx (8.8 KB)
List Account.xlsx (10.3 KB)

2

Hello @Kia1,
Welcome to community

This is your task solutions:
ExcelProcess.zip (18.5 KB)

Download the above file.

You have to refer :

  • Excel Activity
  • For each row in the data table Activity

which is helpful to you regarding this task

Might be it is helpful to you.

Thank you,
Akhil

3

Also refer these steps if you wanna understand the zip file and you want to perform by yourself:

To achieve this in UiPath, you can create a flow using activities like “Read Range” to read data from the “List Account” Excel file and “Write Cell” to write data into the “Data Grafik” Excel file. Here’s a step-by-step guide:

  1. Use the “Read Range” activity to read the data from the “List Account” Excel file and store it in a DataTable variable.
  2. Use a For Each Row activity to iterate through each row of the DataTable obtained from “List Account”.
  3. Inside the For Each Row activity, use the “Get Row Item” activity to retrieve the values from the “Account” and “AM Name” columns.
  4. Use the “Write Cell” activity to write the retrieved values into the corresponding columns in the “Data Grafik” Excel file.
  5. Repeat steps 3 and 4 for each row of data in the “List Account” Excel file.
  6. Finally, save the changes made to the “Data Grafik” Excel file.

By following these steps, you can effectively copy data from the “List Account” Excel file into the “Data Grafik” Excel file in the specified columns.