Excel Data to Sap page

Help Studio
,
1

This is my Excel Data in Column “C”

image
They Are 3 DATA’S

Here i Want to Print the 3 data in this page
image

2

hi @krishnapriya_Anu

Construct a string variable by looping on the rows and G_L-Account column.

Before loop initialize GLAccounts=“”
Inside the loop use assign activity
Append them like GlAccounts= GLAccounts+ Environment.Newline+ CurrentRow(“G_L-Account”).toString
out of loop: GLAccounts= GLAccounts.Trim
Copy to Clipboard
and go in SAP, use send keystrokes: Ctrl+V there.

You can try the type into activity as well.

Thanks

Happy Automation! :smiley:

3

Can u explain briefly
Plz
Like a Flow

4

This is the steps for the flow,
Assign GLAccounts=“”
For each Row in DataTable on dtRecords
Assign GlAccounts= GLAccounts+ Environment.Newline+ CurrentRow(“G_L-Account”).toString

Exit loop

out of loop: GLAccounts= GLAccounts.Trim
Set to Clipboard activity, pass GLAccounts as input

and go in SAP page , use send keystrokes activity : Ctrl+V

5

@krishnapriya_Anu

Just use a for each row in datatable then use type into and then a send hot key to move the cotrol to down inside the loop…so tht it types and again moves down

Or can concatenate all 3 with new line and see if that is automatically taken by sap as 3 lines

Cheers