Solved Failed to paste from clipboard: PasteSpecial method of Range class failed.

#1
Hi Everyone,

I was trying to copy the data from a window(tabular form is getting copied as text) into excel. But, the data isn't copying. I tried to get that into a collection with GetClipboard(), pops compatibility trouble here(cannot convert text). What is the flow to solve this?

Thanks!
 

VJR

Well-Known Member
Staff member
#2
I tried to get that into a collection with GetClipboard()
The output of GetClipboard action is a Text and not a Collection. Not sure how you are doing that in a Collection. Is this a feature in any of the new BP versions?

But, the data isn't copying
Do you mean copying OR pasting?
While stepping through (F10) do the copying action through BP and then manually go to Notepad and paste there and see what happens.
If it is pasted then data is copied onto the Clipboard and if not then data is not going into the Clipboard itself and then the next course of action needs to be determined based on what is your observation on the above.
 
#3
I meant pasting(apologies), I copied the table data and then used split lines and split text to get into an appropriate form of collection.
Thanks, for responding. :)
 
#6
@Dhwani24 You should try using the split lines / split text from Utility - Strings internal object.
Apologies for the delayed response.
My data table has tab as separator.. when split text is used after split lines, the collection is splitting into rows instead of the original columns ways.. can you share your method how you resolved yours?
 
#7
I am copying data from pdf through ctrl+a, ctrl+c, and using getclipboard() function in the calc stage storing the result in the data item. the text is not able to be copied in the same way it is present in the pdf. I am getting something like this :
Expression Result = <process name="__selection__PDF" type="object" runmode="Exclusive"><stage stageid="6801af91-d71b-4643-8778-69bce440d07c" name="PDF using regex" type="SubSheetInfo"><subsheetid>5d91d8e7-14ea-491f-aa2c-925a7ffb0f7f</subsheetid><display x="-240" y="-45" w="150" h="90" /></stage><stage stageid="f27cbc15-66bb-4cd5-b648-83bbb8331931" name="Start" type="Start"><subsheetid>5d91d8e7-14ea-491f-aa2c-925a7ffb0f7f</subsheetid><loginhibit /><display x="0" y="-315" /><onsuccess>ce0b7073-

and the result should be
Siemens Gamesa Renewable Energy Limited,
Unit 9B, 4 Quick Silver Way,
Cobalt Park
Newcastle Upon Tyne, NE27 0QQ
Siemens Gamesa Renewable Energy A/S
Borupvej 16
7330 BRANDE
DENMARK
Purchase Order 5000500306
Purchase order no. Supplier no.
5000500306 1030
Purchase order date Currency
10.04.2020 EUR ... something like this.
Can somebody help in copying the exact data
 
#8
I am copying data from pdf through ctrl+a, ctrl+c, and using getclipboard() function in the calc stage storing the result in the data item. the text is not able to be copied in the same way it is present in the pdf. I am getting something like this :
Expression Result = <process name="__selection__PDF" type="object" runmode="Exclusive"><stage stageid="6801af91-d71b-4643-8778-69bce440d07c" name="PDF using regex" type="SubSheetInfo"><subsheetid>5d91d8e7-14ea-491f-aa2c-925a7ffb0f7f</subsheetid><display x="-240" y="-45" w="150" h="90" /></stage><stage stageid="f27cbc15-66bb-4cd5-b648-83bbb8331931" name="Start" type="Start"><subsheetid>5d91d8e7-14ea-491f-aa2c-925a7ffb0f7f</subsheetid><loginhibit /><display x="0" y="-315" /><onsuccess>ce0b7073-

and the result should be
Siemens Gamesa Renewable Energy Limited,
Unit 9B, 4 Quick Silver Way,
Cobalt Park
Newcastle Upon Tyne, NE27 0QQ
Siemens Gamesa Renewable Energy A/S
Borupvej 16
7330 BRANDE
DENMARK
Purchase Order 5000500306
Purchase order no. Supplier no.
5000500306 1030
Purchase order date Currency
10.04.2020 EUR ... something like this.
Can somebody help in copying the exact data
please tell the soln
 
Top