DannyJ3al Posted March 16, 2016 Share Posted March 16, 2016 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 Link to comment Share on other sites More sharing options...
water Posted March 16, 2016 Share Posted March 16, 2016 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. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
DannyJ3al Posted March 16, 2016 Author Share Posted March 16, 2016 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 Link to comment Share on other sites More sharing options...
water Posted March 16, 2016 Share Posted March 16, 2016 Which browser do you intend to use? AutoIt comes with an UDF for the Internet Explorer. More UDFs for other browsers are available. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
DannyJ3al Posted March 16, 2016 Author Share Posted March 16, 2016 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 Link to comment Share on other sites More sharing options...
water Posted March 16, 2016 Share Posted March 16, 2016 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 My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
DannyJ3al Posted March 16, 2016 Author Share Posted March 16, 2016 Thanks Would you know how I get a value from the array and using the send command write that to a field? Link to comment Share on other sites More sharing options...
water Posted March 16, 2016 Share Posted March 16, 2016 You know that Send is not very reliable because it might depend on user action etc? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
DannyJ3al Posted March 17, 2016 Author Share Posted March 17, 2016 Yeah that's fine only using send for another program to contain the data which is a bespoke program. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now