Create excel file on the basis of name and put the data one by one on the basis of name

Help Activities
, ,
1

I have an excel file and i want to put data on the basis of name to other excel.

Please let me know the flow
what should i do
image

2

Basic on name of your column, your asking put the exfile name or sheets name dynamically

@office_work

3

1.First you need to read the excel file by using the
read range activity suppos the out = dt

And pass in the for each row data table

2.In the loop all the process you can use the
Write Range Activity and in the path you can mention like this

Condition= curreentRow(“names”).Tostring+“.xlsx”

Then it will create the dynamic excel file with names

@office_work

4

Hi @office_work

To copy data from one Excel file to another based on a specific criterion (e.g., name) using UiPath, you can follow these steps:

    • Use the “Excel Application Scope” activity to open the source Excel file.
  • Use the “Read Range” activity to read the data from the source Excel sheet into a DataTable.
    • Use DataTable activities to filter the data based on the name criterion. You can use the “Filter Data Table” activity or write custom logic to filter rows where the name matches your desired criteria.
    • If needed, create a new DataTable to store the filtered data. You can use the “Build Data Table” activity to define the structure of the new table.
    • Use the “Excel Application Scope” activity to open the destination Excel file.
  • Use the “Write Range” activity to write the filtered data (either the entire DataTable or the rows that meet the criterion) to the destination Excel sheet.
    • Save and close the destination Excel file using the “Save Workbook” and “Close Workbook” activities within the “Excel Application Scope.”
    • Close the “Excel Application Scope” for both the source and destination files.

You can adjust the filtering logic, column names, and other details based on your specific Excel files and criteria.

Thanks!!