Copy from excel and paste in the SAP


I am new in Uipath.
I would like to copy Sales order# from excel (Column A) and paste in SAP.
After open the sales order, it will double click on the line#. Its urgent, Please help me.

Column A Column B
Sales Order# Line#
1245896 100



  1. Use Read Cell activity to read the Sales order number from Excel file and it will give output as String. Let’s say ‘SalesOrder’.

  2. Then use Type Into activity and indicate the field in SAP application and pass SalesOrder variable to it.


Hope these steps would help you resolve this

May be i will mention two different approach on two different scenarios

First one if the datatable has more records in it

  1. Use a excel application scope and pass the file path as input and inside the scope use a READ Range activity and get the output as dt

  2. Then use a FOR EACH ROW activity and pass the above variable dt as input

  3. Inside the loop use a TYPE INTO Activity and mention as

This will type in the value from each row one by one


If it has only record in it that is in the datatable


  1. Use a excel application scope and pass the file path as input and inside the scope use a READ CELL activity mention the cell position in the excel and get the output of type string named

  2. Then use a TYPE INTO activity and pass the above variable as input

Cheers @Asitabha_Deb_asitabhad

HI @Palaniyappan ,

Thanks for your reply. Yes, it is working fine.
But, if there are multiple SO# in excel and would like to enter SO, one by one in SAP.
Sales Document

First BOT will enter first SO, based on the line number, BOT will double click on exact line number, process certain activity, save, exit and then enter second order and so on.

I hope you will understand my requirement.


HI @Asitabha_Deb_asitabhad

Please check my training explaining how to import data from Excel to SAP

Go here: SAP Academy course

Best regards, Lev

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