I have 2 excel with same headers

Help Studio
, ,
1

I have 2 excel with same headers now i want to write the data of the excel 2 to excel 1 but excel 2 headers should not be written again in excel 1
How do i do it

2

@Girid
read 2 excels files and pass the datable2 to the destination Datatable1

use merge datatable activity

image
image658×550 19.2 KB

cheers

3

Read Range both into separate datatables. Merge Data Table. Append/Write Range to new Excel file.

If you really need to write directly to the existing Excel 1 file, then Read Range Excel 2 into a datatable then Append Range to Excel 1 but uncheck the add headers box.

4

Hey @Girid ,

Read both excel and then use a merge datatable activity
Make sure that the property MissingSchemaAction: Add

image
image1749×733 54 KB

s

Hope it helps you !

5

Can you tell me more about merge activity

6

Hey @Girid Please refer below website
https://docs.uipath.com/activities/other/latest/workflow/merge-data-table

Also please refer below video

Hope it helps you!

1 Like
7

Thank you for the references

8

@Girid

yes merge datatable activity contains to fileds source and destination

if both the tables have same columns then this activity makes the data below the destination Datatable,

https://docs.uipath.com/activities/other/latest/workflow/merge-data-table

for better understanding refer this

cheers

9

If you just go to Google and type in UiPath plus the activity name, you’ll find lots of information including links to the UiPath documentation about the activity.

10

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