Jump to content
Sign in to follow this  
13lack13lade

Displaying an Excel cell in autoit GUI

Recommended Posts

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!

Share this post


Link to post
Share on other sites
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!

Share this post


Link to post
Share on other sites
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.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - 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
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.


AutoIt.4.Life Clubrooms - Life is like a Donut (secret key)

Make sure brain is in gear before opening mouth!
Remember, what is not said, can be just as important as what is said.

Spoiler

What is the Secret Key? Life is like a Donut

If I put effort into communication, I expect you to read properly & fully, or just not comment.
Ignoring those who try to divert conversation with irrelevancies.
If I'm intent on insulting you or being rude, I will be obvious, not ambiguous about it.
I'm only big and bad, to those who have an over-active imagination.

I may have the Artistic Liesense ;) to disagree with you. TheSaint's Toolbox (be advised many downloads are not working due to ISP screwup with my storage)

userbar.png

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  

×