Pasting data table into SAP

[gabrieltwn93 (Gabriel Tai)]

Hi there,

Currently I’m trying to copy few rows from an excel into a SAP pop, which required to fill multiple cells vertically, anyone tried this before ? Thanks !

Cheers,
Gab

[vikaskulhari]

Hi @gabrieltwn93

You can check it out

Autofill Range in SAP

Hi @Sajuri, your question is not that much clear to me however I’m trying to answer you. I think you are creating an order and in that order you need to insert multiple items but the problem is - you dunno how many rows are there, right? So in order to get the visible row counts you can use below VB Script command and loop through your program till last line - Session.FindById("wnd[0]/usr/cntlGRID1/shellcont/shell/shellcont[1]/shell").RowCount-1 Replace the ID(“wnd[0]/usr/cntlGRID1/shellco…

[Sajuri (Kateřina Hajná)]

Hi @gabrieltwn93,

I was dealing with the same problem. You must read range in Excel and create For Each Row

PNsExcel is your range in excel. Try to insert a message box before For Each Row

[Birdi (Harwinder Birdi)]

You could also copy the whole column from the Datatable and set to clipboard and paste it into the SAP.

[Malvin_Aubin_Darpito]

Hi,
Could you tell me how to do it?
Thanks

[LevKushnir]

HI @Malvin_Aubin_Darpito

please describe your situation in more details and please create a new thread. This is 3 years old and not relevant anymore

Thanks, Lev