Sign in to follow this  
Followers 0
bdavis

Newbie Help - Reading excel data to populate webform

3 posts in this topic

Hi all,

First of all please excuse my ignorance. I am very new to autoit and still very much trying to get the hang of it all.

If someone could possibly assist (or possibly point me in the right direction if this particular wheel has already been invented!) that would be awesome.

What I am after is to develop a script that can extract data out of columns in excel and use this data to populate a webform. As the webform is a workplace database I cannot provide much detail and will likely need to figure that bit out myself, however if I could get some help on setting up a script that can read/extract data out of excel and the basics on inserting that data onto a webform, that would be great.

If some additional details help, please feel free to ask and I will try and provide what I can. I would need the script to loop, as each row of data would relate to a new 'matter' in this database. The data will generally be in two columns in the spreadsheet, however the option for more columns would be great in case it is needed down the track.

Many thanks in advance for any assistance with this. Much appreciated!

Share this post


Link to post
Share on other sites



Use the excel udf. This can use callback functions to detect changes in your excel spreadsheet.

Share this post


Link to post
Share on other sites

The latest beta comes with the most current version of the rewritten Excel UDF. Either use the _Excel_RangeRead function or wait for an event that is triggered when a user enters some data into a cell.

To populate a web form depends on the browser you use. UDFs are available for IE, FF at least.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0