Hi,
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
BR/Deb
Use Read Cell activity to read the Sales order number from Excel file and it will give output as String. Let’s say ‘SalesOrder’.
Then use Type Into activity and indicate the field in SAP application and pass SalesOrder variable to it.
Hi
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
row(“yourcolumnname”).ToString
This will type in the value from each row one by one
Or
If it has only record in it that is in the datatable
Then
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
str_output
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
608024348-100
608006961-200
608007552-300
607930997-400
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.
BR/Deb
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.
ashokkarale