Copying Values from Excel to a Specific Section in SAP

[Ishan_Shelke]

I have these set of 55 values in excel which I am tring to copy to a section in SAP but I am not sure what activity to use here.

The Set of Values :

The Section of SAP in which I want to paste them :

i want to copy all 55 values into these boxes which you can see

[supermanPunch (Arpan)]

Hi @Ishan_Shelke ,

You can try following the below Steps :

1. Considering DT is the datatable where the column values are present. We could select all the column values or a limited count of the values as required and then convert it to an array of string.

valueArray = DT.AsEnumerable.Select(Function(x)x("yourColumnNameOrIndex").ToString).Take(55).ToArray

Here, valueArray is of the type Array of String.

2. Combine the individual values of the array to a String with Environment.NewLine as it’s separator.

combinedValue = String.Join(Environment.NewLine,valueArray)

Here, combinedValue is of the type String.

3. Next, Use Set to Clipboard activity with the value as combinedValue variable.

4. You can perform the Click on the Paste button in SAP which should populate the rows in SAP table.

Also .Take(55) can be removed if you are not limiting the numbers of rows to be taken.

Let us know if this doesn’t work.