How to paste clipboard data to excel file

Hello Community,

I have scenario where i need to click on copy table of SAP, and create a new excel file and paste copied data from clipboard.

@NIVED_NAMBIAR @Krishna_547 Need Suggestions

Hi @ShivuDundi

Hi @ShivuDundi u can try the following way

  1. Use get from clipboard activity to get the data from clipboard and store in string varible let’s say input

  2. Use generate datatable activitiy to convert the input to datatable and store the output in dt1(since u had copied the table.from sap)

  3. Use write range to write the datatable to excel file

Hope it helps you


Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed::relaxed:

I see that @Nived has already given you the approach. In addition to it, you may need to manipulate your string. That is because, your string may have Tab spaces or Semicolons etc., which will need to be handled before the Generate DataTable can use the string. Here is the approach for converting input clipboard strings with Tabs in them.


Image of the workflow.

I don’t have excel so I use write range (Workbook) activity: CopyClipboardToExcel.xaml (10.4 KB)

1 Like

thank you @jeevith

Got it @NIVED_NAMBIAR Thank you

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