Newbie Help - Reading excel data to populate webform

[bdavis]

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!

[Geir1983]

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

[water]

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.