topic RE: Copy Data from Excel and Paste in SAP in Product Forum

Copy Data from Excel and Paste in SAP

AsitabhaDeb — Wed, 09 Sep 2020 18:06:00 GMT

Hi,

I would like to copy data from excel and paste in the SAP in the specific field at a time. will it be possible.
For e.g - Copy Storage location from excel and paste in SAP in same field.
Copy warehouse no from Excel and paste in SAP in same field.

Please help me to solve this issue.

Thanks,
Deb

------------------------------
Asitabha Deb
------------------------------

RE: Copy Data from Excel and Paste in SAP

shashank.kumar280 — Thu, 10 Sep 2020 13:34:00 GMT

Hi Asitabha,

Here I am assuming that you are able to get the cell location of the data you want to copy and you have modeled an object for SAP application. You can use the Get Cell action in MS Excel VBO to get the cell data and use a write stage to enter the value in the SAP application.
If my assumption is incorrect then you will first have to first build logic to locate the field you want to copy/update in Excel/SAP and then go about executing them together. Let me know if that helps.

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: Copy Data from Excel and Paste in SAP

NileshJadhavBP — Thu, 10 Sep 2020 20:37:00 GMT

Hi Asitabha,

Yes you can do that.

Get all data into collection from excel using MS excel vbo and you have to use write stage to paste excel collection data into your application field.

Please reply if you need more clarity.

Thanks
Nilesh

------------------------------
Nilesh Jadhav
Senior RPA Specialist
ADP
Pune
------------------------------

RE: Copy Data from Excel and Paste in SAP

AsitabhaDeb — Fri, 11 Sep 2020 06:49:00 GMT

Thanks Nilesh for your reply. I will try and update you

BR/Asitabha

------------------------------
Asitabha Deb
------------------------------

RE: Copy Data from Excel and Paste in SAP

AsitabhaDeb — Fri, 11 Sep 2020 06:51:00 GMT

Thanks Shashank .

Let me try this one and will update you.

BR/Asitabha

------------------------------
Asitabha Deb
------------------------------