Want to merge two excel file in datatble

Help Studio
, ,
1

Hi all,

I Want to merge two excel file in datatble and want print all values after merging the datatble.
All excel file have same structure like all columns so no issue to merge.

Please guide or create a workflow so i can do same. fast pls.
thanks

2

Hi @RPA_Learner0

Pls use this steps,
Read Range (First Excel) → dt1
Read Range (Second Excel) → dt2
Merge DataTable (dt2 into dt1)
Output DataTable (dt1) → mergedString
Write Line (mergedString)

Or let me know i’ll create workflow sample.
Happy automation

3

Yes pls create a sample workflow. thanks

4

Hi @RPA_Learner0

Can you try this

The image shows a workflow in which data is read from "Sheet1" of an Excel workbook and appended to "Sheet2" in the same workbook using UiPath activities. (Captioned by AI)
The image shows a workflow in which data is read from "Sheet1" of an Excel workbook and appended to "Sheet2" in the same workbook using UiPath activities. (Captioned by AI)576×360 11.8 KB

Input:(Sheet1)

The image shows a spreadsheet with two labeled columns, "Name" and "ID," containing five rows of data listing names and their corresponding IDs. (Captioned by AI)
The image shows a spreadsheet with two labeled columns, "Name" and "ID," containing five rows of data listing names and their corresponding IDs. (Captioned by AI)477×445 4.27 KB

Input:(Sheet2)

A spreadsheet with two columns labeled "Name" and "ID," with names "def," "ghi," and "jkl" corresponding to IDs 12, 34, and 56, respectively. (Captioned by AI)
A spreadsheet with two columns labeled "Name" and "ID," with names "def," "ghi," and "jkl" corresponding to IDs 12, 34, and 56, respectively. (Captioned by AI)472×368 3.4 KB

Output:(Sheet2)

An Excel spreadsheet has a simple two-column format listing names in column A and associated numerical IDs in column B. (Captioned by AI)
An Excel spreadsheet has a simple two-column format listing names in column A and associated numerical IDs in column B. (Captioned by AI)527×462 4.94 KB

Regards,

1 Like
5

Hi @RPA_Learner0

Please check below steps,

This image shows a UiPath workflow where two data tables named DT1 and DT2 are merged, and the output data table is converted to a string labeled as DataTableString with relevant properties and variables displayed on the side. (Captioned by AI)
This image shows a UiPath workflow where two data tables named DT1 and DT2 are merged, and the output data table is converted to a string labeled as DataTableString with relevant properties and variables displayed on the side. (Captioned by AI)1409×791 66.7 KB

Found Helpful, feel free to mark as a solution.

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.