excel question

[jay gordon]

Is it possible to read from an excel spreadsheet (multiple rows & columns) and populate a web page with the values from the spreadsheet

Jay

[rparmani]

Hi jay,

create a task that processes one row of excel for e.g. traverse through various columns using TAB key and copy the cell and paste it in to your application.

Before you stop the task make sure you are on the first column of the next row. you can do that by hitting ENTER and HOME key. That way when you repeat the task using repeat property, it will pick the next row.

[Nick]

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