Copy a range rows from one excel to another

[Stivend19 (Stiven Diaz)]

Good day
I would like to know if you can help me with a problem that I have, I am something new in this from Uipath

I want to copy from an excel file X number of rows (from A2, as you see in image 1) and paste them in another excel on a specific sheet as seen in image 2, but continuing in the last row.
The second file has as a path: C: \ Users \ jesanch1 \ Desktop \ Reports Ltda and Lenovo \ STATE HP LTDA.xlsb

it is assumed that when the download process of image 3 is finished, the process mentioned above must be done

Someone help me please.

Image 1

Image 2

Image 3

[fernando_zuluaga]

hi

UiPath Go ! BalaReva EasyExcel Activities

Hi, I have developed the new activity in the package of BalaReva EasyExcel.Activities .It is called “Copy ToClipboard” .It copies the excel data to the clipboard. (The BalaReva.Excel.Activities have the same activity called “CopyData”) [image] Sample : ExcelCopyPaste.zip (26.4 KB) Thank you Balamurugan.S

this activity can helps you
Regards

[balupad14 (Balamurugan (BalaReva))]

Thank you @fernando_zuluaga,

@Stivend19 and you have an activity called

Find LastRow that to find the last row of the sheet and it returns the row index.

UiPath Go ! BalaReva EasyExcel Activities

Hi , I have developed 2 new activities. Find LastColumn that to find the last column Index and Column Name of the sheet . Find LastRow that to find the last row of the sheet and it returns the row index. [image] [image] Find LastColumn’s Properties : [image] Find LastRow Properties : [image] Note : If the sheet name is empty , It will take the first sheet name . Here is the video demonstration. [UiPath excel Extract Graph as Image | find last column Index| find last Row No…

Regards
Balamurugan.S

[Stivend19 (Stiven Diaz)]

I failed you, you can’t hahahaha :sollozo: :sollozo: :sollozo:

I will attach the files to see if you can help me better

The first file “DO_20191230110225” is from which I want to copy the information (as I was saying the number of rows is changing, it is not always the same)
The second file “ESTADO123” is where I want to paste the information (this will be pasted on the sheet “INSIDE-OUT OF GOAL”), but I want it to be pasted in continuation of the last row

The first file will be found in the path: C: \ Users \ jesanch1 \ Downloads \ DO_20191230110225.xls

The second file will be in the path: C: \ Users \ jesanch1 \ Desktop \ Reports Ltda and Lenovo \ Draft BOT \ STATE123.xlsb

Please help

Borrador BOT.zip (1,1 MB)

[balupad14 (Balamurugan (BalaReva))]

Hi @Stivend19,

No. I won’t say hahahaha (be happy always)

Corrections.

Project : Borrador BOT.zip (1.1 MB)

Thank you
Balamurugan.S

[Stivend19 (Stiven Diaz)]

Do I need to create any variable?

[balupad14 (Balamurugan (BalaReva))]

Yes. To store the row index, you need to create a variable.

Regards
Balamurugan.S