Copy data from one sheet to another sheet in Excel

[mcLauge]

Hello there,

i want to copy all the the data from one sheet of my Excel File to another sheet in the same File. The point is, that I often times don´t know how many rows there will be in my first sheet so i would have to calculate that in my programming in.
Can you please help me?

Kind regards!

[Arpit_Kesharwani]

@mcLauge Use copy sheet activity.

[mcLauge]

i tried it with this activity, but apparently i need another (empty) sheet to copy the data, but i need to overwrite an existing sheet with the copied data. I also tried to read the range from the first sheet and with a write cell/ range activity to write it in the other sheet but that doesn´t work either.

I hope you understand me.

Kind regards!

[Yu_Steven]

I have the same issue. I think that it is the bug of UIPATH.