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#
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
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
Then use a FOR EACH ROW activity and pass the above variable dt as input
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
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
Then use a TYPE INTO activity and pass the above variable as input
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.
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.
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.