I have two excel files where I need to append the data into another file.
So I need to copy all data in “USER ID” column from EXCEL 2 and append the data to EXCEL 1 on the last blank row on column “User ID”. As shown in the picture above (EXCEL 1).
Thank you in advance.
Here is an activity called append row in below. It will help you.
You have to specify the Start Column as “B” and cell range as “B:B”.
I’m not sure if I’m using a different packages but I could not find mentioned activity.
hi, Which version of the package that you are using?
I’m using version 2020.3.3
Apologies. I have posted it the wrong thread. Now I have move it to right place.
The package is BalaReva.EasyExcel.Activities Version 28.1.2.
Check this below code workflow @jenkim
ExcelOps_AddDataToColumn.xaml (8.1 KB)
Hope this may help you
Have you tried the Append Range activity https://docs.uipath.com/activities/docs/append-range?
This activity is available within the UiPath Studio default configuration.
Your solution works as expected. Thank you so much.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.