How to copy dynamic range from excel to SAP

[lab_tool]

i want to make a loop that copy from excel files to SAP.
The details as follow :
Copy every 5 rows to SAP
*First step i want to copy from range B2:B6 and then paste it to SAP,
*second step i wanto to copy from range B7:B11 to SAP
*third step copy from range B12:B16 to SAP

Thanks in advance for the replies and helps.

[Gokul001 (Gokul Balaji)]

Hi @lab_tool

Check out the XAML

12.10.2023_Forum_1.xaml (8.9 KB)

Regard
Gokuls

[Kartheek_Battu]

Hello @lab_tool

Read Range (Excel) → For Each Row (DataTable)
Copy to Clipboard (B2:B6)
Open Application (SAP)
Type Into (SAP)
SAP Automation Activities
Close Application (SAP)

Thanks & Cheers!!!