How can I copy the data in an Excel file 24 rows at a time and paste it into the SAP program?

Learn
1

I have 75 rows in an Excel file. I will copy 24 rows at a time and paste in Sap program.

Capture
Capture1438Ă—704 140 KB

can you help me

Thanks.
Apollo

1 Like
2

Hello there :smiley:
You could use “Read Range” activity to read the excel file and then use “for each row” to pass the data to SAP.

1 Like
3

Can you write an example for me?

Regards,

4

Hope this help you to understand. :slight_smile:
Excel filtering arguments.zip (19.6 KB)

5

Hi
Hope these steps would help you resolve this
—use a START PROCESS activity and pass the filepath of excel as input to FileName property
—this will open the excel file in foreground
—then use a GET ACTIVE WINDOW ACTIVITY and inside that use a Send hot key activity with key as ctrl+g
–then use a type into activity with input as “A1”
—then another send hot key activity with key as ctrl+A to get the whole table
Or
ctrl+shift+down to select that entire column
—then a send hot key activity with key as ctrl+c

—now in SAP window after going to this page use a send hot key activity with key as ctrl+v

Or
If we want to enter the data from excel one by one to this sap window then
—use a read range activity and get the output with a variable of type datatable named dt
—now use a FOR EACH ROW activity and pass dt as input and inside that TYPE INTO activity we can mention the input as row(“yourcolumnname”).ToString

Cheers @Perawat

1 Like