How to import excel data into web application

[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.