How to import excel data into web application

[cheersrpa]

Hi,

I have some data like fname ,lname,salary information in excel. that i need to import in web application ,.How to do that.

Thanks

[Rammohan91 (Rammohan Banda)]

Check this,

How to loop through rows and columns in an excel and pass them to a webpage

Follow the below steps: Use ‘Excel Application Scope’ activity and Add ‘Read Range’ activity inside the scope. Create a DataTable variable and assign it to the output property of Read Range activity. Not all your username and password date is in that DataTable variable. Lets say it is dtCredentials. Now use a ‘For Each Row’ activity after the ‘Excel Application Scope’ activity. Add ‘Assign’ activity inside the for each loop and create string variables named ‘strUserName’. Assign should be like…

Thanks,
Rammohan B.

[indra]

@cheersrpa Refer below link and download zip file for your refernce

Best approach to read many fields from excel and paste /enter on webpage

for simplicity we can consider https://login.oracle.com as its having only two fields. Thanks for the time