Copy Range not finishing

Help Studio
, ,
1

Copy range is never completing. no error is thrown. What can I do?

destination cell “A1”
Destination sheet “sheet2”
Sheet name “sheet1”
Source range"A1:BM10000"

2

@A_Learner,

If using Excel process scope → Read Range is slower.

Try using Read Range workbook activity.

3

Copy range not available for workbook. Looks like only available for Excel process scope.
In 2022.10 is there any other way of accomplishing copy range?

Issue:
Copy range is just hanging there, not sure never coming out, even after copying the data.

Thank you,

4

Hello @A_Learner

If you need to insert the data with no regards to what the second sheet contains, then you could use Read Range Workbook as @ashokkarale suggests and then simply define the same Excel file as you destination in Write Range Workbook, but with a different sheet.

If you are looking to append the data copied, then you first need to read the second sheet to determine the correct index of where to insert data.

Regards
Soren

1 Like
5

Thank you @SorenB for clearly explaining.

Is the above equivalent to selecting “All” option in copy range?
For example, formula, formatting etc.?

Thank you,

1 Like
6

@A_Learner,

Read Range Workbook don’t preserve the format and formulas. If this is important to copy formulas and formats and Excel process scope in not fast enough, you are left with only one option, that is Invoke VBA code activity.

Record the macro in excel. Take it out in a text file and pass it to the activity.

1 Like
7

@ashokkarale
It is just not about taking time, it is never coming out of that activity.
I have to stop the bot. Not sure why.

If copy range works, I do not like to go VB route.

thanks

8

@A_Learner,

Agree! tried upgrading/downgrading the Excel activity package? Sometimes it could be due to due to uncovered issue in some versions.

9

thank you. This works perfectly in UiPath 2022.

Same code in UiPath 2023 having issue.

Any advise here?

thank you

10

@A_Learner,

Can you try matching the Excel Activities package version you were using in 2022 in 2023?

1 Like
11

Trying that. Thank you!!

12

@ashokkarale What does that exactly mean? Upgrade Excel in 2022 to what is being used in 2023?

thank you,

13

@A_Learner,

I mean upgrade /downgrade the UiPath.Excel.Activities package version in your current code to what you were using in 2022

15

Thank you, @ashokkarale and @SorenB

2 Likes
16

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