Excel Spreadsheet

[DannyJ3al 0]

Hi everyone 

I am fairly new to AutoIT and I am looking to take the data from a spreadsheet (excel) and input the data from each column row by row into a webpage for testing.

The spreadsheet column headings are First Name, Last Name, D.O.B, Vehicle Registration.

I am then looking to map the first row of data into a webpage automate the functions on the webpage (something I can already do) and then move onto the next row for the next test.

Please could some help me write a script for this.

Many Thanks

Dan 

P.s I am using Version 3.5.4 

 

[water 1,657]

Welcome to AutoIt and the forum!
AutoIt comes with an Excel UDF that provides all functions you need to process your Excel workbook:

• _Excel_Open
• _Excel_BookOpen
• _Excel_RangeRead
• _Excel_BookClose
• _Excel_Close

Please check this functions (and example scritps) in the help file.

[DannyJ3al 0]

Thanks for the reply!

I have managed to now pull the data I need and put this into an Array I just need to know how I can now get the data from one cell and make that available to be populated into the website.

Thanks

Dan

[water 1,657]

Which browser do you intend to use? AutoIt comes with an UDF for the Internet Explorer. More UDFs for other browsers are available.

[DannyJ3al 0]

Chrome  

Im more worried about making the data available than getting it into the fields on the web page. But I need all the help I can get haha

[water 1,657]

For Chrome you could either use http://www.autoitscript.com/forum/index.php?showtopic=154439

or http://www.autoitscript.com/forum/index.php?showtopic=153520

[DannyJ3al 0]

Thanks

Would you know how I get a value from the array and using the send command write that to a field?

[water 1,657]

You know that Send is not very reliable because it might depend on user action etc?

[DannyJ3al 0]

Yeah that's fine only using send for another program to contain the data which is a bespoke program.