Copy from excel and paste in the SAP

Help Activities
, ,
1

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

2

@Asitabha_Deb_asitabhad

  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.

3

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

  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
    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

  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
    str_output

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

Cheers @Asitabha_Deb_asitabhad

4

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

5

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

6

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