Need read 2 excel value in same time

Help Community
,
3

Hi @Aarthy1

Follow the below steps to achieve as you expected,
→ Use the Read range workbook activity to read the input sheet and store in a datatable called dt_Input.
→ Then use the Build datatable activity and create two columns Head and Name.
→ Create a variable to the Build datatable activity called dt_Output.
→ Then use the Assign activity to write the below LINQ Expression,

- Assign -> dt_Output = (From row In dt_Input.AsEnumerable
                         Let Head = row("Head").ToString
                         Let Name = row("First").ToString+row("Last").ToString
                         Select dt_Output.Rows.Add({Head, Name})
                              ).Copytodatatable()

→ Then use the Write range workbook activity to write the dt_Output to output sheet in same excel.

Check the below workflow screenshot for you reference,

The image illustrates a workflow sequence in UiPath for reading data from an Excel workbook, processing it into a data table, assigning the output to a variable, and writing the data back to another sheet in the same workbook. (Captioned by AI)
The image illustrates a workflow sequence in UiPath for reading data from an Excel workbook, processing it into a data table, assigning the output to a variable, and writing the data back to another sheet in the same workbook. (Captioned by AI)909×668 40 KB

Hope it helps!!