Store copied data from clipboard in a datatable

Help Activities
, , ,
1

How to store copied data from clipboard into datatable??
Tia …

2

@sheetal_Bora

If you have the clipboard, use Get from clipboard activity and declare a variable for the output

Then you have to give an Assign activity and write as below

DatatableVarable.Rows(0).Item(“ColumName”) = ClipboardVariable

Hope this may help you

Thanks

3

Not in particular column… like each value shall be updated in respective column

4

image
image1920×1440 573 KB

5

Hi Shital,

First of all, you cannot build datable from things copied on clipboard.
The reason for that is, the datatype of content saved on clipboard is System.String.

Therefore, if you copy table from excel, all content saved as String not a datatable.

You can easily confirm that by knowing datatype of content copied on clipboard:
Use assign activity: Var_A= Var_CopedText.GetType

Please find below image for reference

image
image981×346 18.4 KB