Copy Multiple cells from Excel to SAP by UiPath Studio

Help Activities
, , , , , ,
1

Multiple Selection
Multiple Selection687Ă—333 19.3 KB

Hi Everyone
I faced with attached error after running activity. Please guide me.
Thanks

2

Hi @mnmohajeri,

Can you please share more details on what are trying to do?

When you do this task manually and paste the value you want in the required cell, do you still get this pop up?

Regards
SOnali

3

Dear Sonalia,

I want to copy multiple cells range “A2:A” from Excel to SAP report as MB52 but I faced with error.
Please let me relevant solution.

Many thanks and regards
Mehran

4

@mnmohajeri,

Are you able to do it manually? If yes, what steps do you take to perform this activity?

If I remember correctly, you can try using Set To Clipboard activity to copy the desired excel range and use Get From Clipboard to paste it into SAP.

5

Thanks buddy, I’ll check and let you the result.

BR
Mehran

1 Like
6

@mnmohajeri

Welcome to the community

What activity are you using to copy?

Generally we read the whole data as A2:A might not be valid input range of excel related activities…so read A:A into datatable and generally on clipboard the value would be like with new characters so use string.join(environment.NewLine,dt.AsEnumerable.Select(function(x) x(0).ToString)) and set to clipboard and use it with ctrl+v to paste on sap..the issue of range also would be gone with this

Cheers

1 Like
7

Many thanks dear Anil

1 Like