How to paste clipboard data to excel file

Help
, , ,
1

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.

2

@NIVED_NAMBIAR @Krishna_547 Need Suggestions

3

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

Regards

Nived N :robot:

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

4

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

Image of the workflow.

image
image316×806 21.5 KB

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

1 Like
5

thank you @jeevith

6

Got it @NIVED_NAMBIAR Thank you

7

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