How to copy a certain column from a desired position an dpaste into SAP field

Hello guys,

I have some doubts regarding SAP and Excel. The problem statement is that -
Tcs_1st_Part
In the above picture I have to copy all the numbers from “DocumentNo” column and paste into
Tcs_2nd_part “Single value” column.

Can you please tell me how can I resolve this?

Regards,
Nirmalya Sarkar

@nirmalya.sarkar

Try below steps.

  1. Use Read Range activity to read the DocumentNo column from Excel file and it will give output as DataTable.

  2. And then use Output DataTable activity and pass above DataTable to it. This activity will convert DataTable into String.

  3. And then use Set To Clipboard activity and pass above String to it.

  4. In SAP application, we have an option called Upload from Clipboard. You will find this option at bottom right corner in that window. Use Click activity and indicate that option then it will write all document numbers into the SAP application.

@lakshman ,

Thank you. It worked.

If i face some problem further, can you help me out??

1 Like

@nirmalya.sarkar

Sure. I will help you.

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