How to write data from excel file to SAP

Help Activities
1

Hi,

Gen excel.xlsx (10.7 KB)

image
image747×538 4.18 KB

These excel file data has to be written into sap application. How to write I used type into activity but data overwriting. Please help.

Thanks,
Lakshmi

2

@lakshmi.mp

Do you need to write each row of data from excel to each row in the form here?

3

Hi @Rahul_Unnikrishnan
Yes each and every row needs to be written form

4

@lakshmi.mp can you try output datatable activity and converting datatable to string and use TypeInto activity.

i think it should work here.

5

@Rahul_Unnikrishnan ok I will try Thank you

6

@Rahul_Unnikrishnan, Converted into string and used type into data writing on same line not moving to next line. What needs to do.

7

@lakshmi.mp is it typing entire text or still the same? Also is there any character limitation for each line in SAP?

8

@Rahul_Unnikrishnan Same as pervious, character limitation is there that part is solved but not moving to next line over writing

9

Got it…The you will have to use for each row in datatable and in the TypeInto activity, use after the variable give a keypress also.

Ater adding the variable in the Typeinto activity, click on the + button and select the button, which will help to navigate to the next line.

You can check manually and confirm the button( either enter or tab will do)

image

10

image
Tried out same over writing

11

in the Selector is there any attribute like rowNum? Can you please share the selector here?

Also as per the screenshot you have selected the first row in the Text area.Can you try to input some multiple lines and heck manually.

12

image
image1916×938 47.5 KB

image
image1920×1080 139 KB

Please look on it.

13

Assign listArray=(From row in yourdt.AsEnumerable() select convert.ToString(row(“0”))).tolist()
use set to clipboard activity string.Join(environment.NewLine.ToCharArray,listArray)
send hotkey Ctrl+V
Please try this

1 Like
14

Hi @Lak_Ui,
Thanks for the solution, its working now.

Regards,
Lakshmi MP

1 Like
15

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