Append to blank row

Help
, ,
1

Hi,

I have two excel files where I need to append the data into another file.

EXCEL 1:
image

EXCEL 2:
image

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.

2

HI @jenkim,

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”.

Thank you
Balamurugan.S

3

Hi @balupad14,

I’m not sure if I’m using a different packages but I could not find mentioned activity.

image
image331×519 7.36 KB

4

hi, Which version of the package that you are using?

Thank you
Balamurugan.S

5

I’m using version 2020.3.3

image

6

HI @jenkim,

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.

Thank you
Balamurugan.S

1 Like
7

Check this below code workflow @jenkim
ExcelOps_AddDataToColumn.xaml (8.1 KB)

Hope this may help you :slight_smile:

1 Like
8

Hi @jenkim,

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.

Best regards,
Marius

9

Hi @Manish540,

Your solution works as expected. Thank you so much.

10

@jenkim :slight_smile: :+1:

11

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