topic RE: The ""Get Clipboard"" action… in Product Forum

Get Clipboard to Collection

GertLõhmus — Mon, 23 Apr 2018 18:39:00 GMT

I would like to get my Clipboard information to a collection. I was trying to construct this in C# but so far I have failed. Was wondering if anyone already has this code stage for this prepared and would be willing to share as I could not find this in any of the common objects. hope this is more or less the place where to enter this post.

try pasting data from…

GautamMishra — Wed, 25 Apr 2018 14:55:00 GMT

try pasting data from clipboard to excel and from there get it in collection

You don't need to paste data…

Martynas — Wed, 25 Apr 2018 15:23:00 GMT

You don't need to paste data - there's a lot more convenient action Get Clipboard under object Utility - Environment (import ""C:\Program Files\Blue Prism Limited\Blue Prism Automate\VBO\BPA Object - Utility - Environment.xml"" if you don't have it).

Wrote it in C#…

GertLõhmus — Wed, 25 Apr 2018 16:52:00 GMT

Wrote it in C#. I wanted to avoid Excel and I wanted to enter the table to Collection. Thank you!

The ""Get Clipboard"" action…

NicholasRudy — Wed, 25 Apr 2018 23:52:00 GMT

The ""Get Clipboard"" action mentioned above, could be combined with the ""Get CSV as collection"" action in the ""Utility - Strings"" VBO, if your data is able to be converted into CSV format. Also, if you want to reduce the amount of coding, you could start with the ""Get CSV as collection"" action and use a pipe as a delimiter. This would substantially reduce the amount of coding required to accomplish what you were trying to do.

RE: The ""Get Clipboard"" action…

SandeepSatish — Wed, 06 Jan 2021 07:49:00 GMT

Hi , Is there a way to copy data from collection to clipboard directly?

------------------------------
Sandeep Satish
IT Architect
Agilent Technologies
Asia/Kolkata
------------------------------

RE: The ""Get Clipboard"" action…

John__Carter — Thu, 07 Jan 2021 10:54:00 GMT

Hi Sandeep - in a word, no.

However it can be done by using a code stage to manufacture a .Net DataTable, populate it with data from the clipboard, and output it as a BP collection. And how the clipboard data is structured will determine how much effort is required to shape it into a DataTable. I think utilities for CSV and JSON are available.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------