Displaying an Excel cell in autoit GUI

[13lack13lade]

Hi Team,

Just wondering where abouts in the help file i would find how to display whats in a cell inside an Autoit Gui..

For example: I have a spreadsheet where the last report ran date is always in the same filed so i want to have my autoit GUI 'linked' to that excel spreadsheet or array to read the cell and display it through text on my GUI.

How do i go about  doing this or what is the right direction i should be heading?? 

 

Thanks guys!

[13lack13lade]

So i need to be able to display a table from excel aswell as have an individual 'field' linked to an excel sheet so when it is changed, it changes on the GUI.. if i can get help with linking 1 field im sure linking an entire table is done the exact same way? thanks guys!

[water]

To just display a single cell in a GUI I would read the content of the cell and display it in the GUI.

Then check the file date/time in a loop. if it changes read and display the cell again.

To display a whole sheet I would embed Excel in your GUI. Check GUICtrlCreateObj.

[TheSaint]

Check out the Excel Management UDF (User Defined Functions Reference) in the Help file.

Depending on what you want to use results for, a basic ListView might be enough in your GUI.