Copy values of particular column and paste the column values all at a time in SAP

Help Studio
, ,
22

try to read range the whole sheet and take the row count to get the total number of rows present and then read the sheet again by specifiying the range as starting cell as for eg: E1:E(dt.rowcount)

image
image972×501 22.1 KB

23

@Sirisha_Siri do this to convert your excel column (trasnaction Confirmed) into a text file then
test12.xaml (8.5 KB)

  1. read range to DT
  2. assign dt.AsEnumerable.Select(function(x) x.field(of string)("Transaction Confirmed")).ToList to transactionConfirmedList
  3. write String.Join(environment.NewLine, transactionConfirmedList) to “testFile.txt”

now testFile.txt will look like this
image

you can use this file to import all the values to SAP…

if you just want to paste instead of importing text file, you can just paste String.Join(environment.NewLine, transactionConfirmedList) into SAP

24

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