Jay,
Yes this is possible. Save your Excel File to a .csv (From the File Menu in Excel) This is much faster than keystrokes.
In automation anywhere you can create a step to loop through the .csv and populate the web page using the web recorder functions.
When you read from a database or .csv file use the $Dataset Column(1)$ variable
For example let say you have 2 columns in your csv file. Name and PhoneNumber
If you wanted to pull over the PhoneNumber you would use $Dataset Column(2)$
Below is the connection string for a .csv file. You will need to change the path to point to your .csv file
Step1
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\webpage\load\;Extended Properties="text;HDR=YES;FMT=Delimited";Persist Security Info=False
Next you will need to add the SQL Step (SQL Query)
Step2
SELECT * FROM NameOfYourFile.csv
Step3
Next you will need to loop through each row in a SQL query dataset
Add steps to populate web page fields (use the web recorder from the tools menu) you can always convert the constants to database variables after recording.
Don’t forget to add disconnect step |