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

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)

@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

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

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