IS it even possible to create working spreadsheets within AutoIt GUI , help with directions and ideas insideBy GarnetDagger
Hello friends, I need some help and ideas because I am a tiny bit lost here!
I am building some GUI with some tools and one of my tabs allows me to retrieve Data from my database in pre-defined ways I prefer.
Currently, I can just look at them as in a Listview so no editing allowed I believe(*if I am wrong please correct me), but my dream is that I can have full control over it as in a spreadsheet program such as excel and open office.
what I like to include is for example;
click cell to edit,
Move cursor to next left, top, down or right cell, and make the cells bigger or smaller
mouse over functions (for example a product info or picture loading etc),
Enter to save temporary data in the cell / field or right away update it to my database also,
Right mouse click for options etc,
drag my cells and columns to edit
select multiple* rows / columns etc
the whole basic shenanigans i guess.
this seems to be a daunting task for a beginner like me and I Know I am not a great programmer myself either. but I got time on my hand and I am very interested in how to accomplish this if possible, has it been done before and if not why not?!?!?! , The options I want in bold are required for the bare minimum to make things remotely work.
Can I have some small guidance on this? I am under the impression that the AutoIt itself does not have these functions or possibilities, can I program this myself and how? Do I need to start accessing resources outside AutoIt and for example need to start learning win32 GUI programming or whatever it is called?
I have tried the search for a while but I am at a loss.
any help is appreciated and I will try to contribute myself as much as possible and I want to emphasize that I really Require the ELI5 (explain me like I am 5 years old) approach!
thank you so much for reading and your time! Regards Rene
What is the most efficient way for AutoIt to check for the existence (and potentially basic properties) of cloud-based (googleDrive, dropBox, etc...) files?
Anybody have experience/ideas about doing this?
I wrote a script that is designed to log at least 10,000 lines of data. While timing it in the beginning, I figured this will take a while so I decided to afk. I came back shortly and found an error came up in the script
C:\Program Files (x86)\AutoIt3\Include\Excel.au3 (451) : ==> The requested action with this object has failed.: $oExcel.Activesheet.Cells($sRangeOrRow, $iColumn).Value = $sValue $oExcel.Activesheet.Cells($sRangeOrRow, $iColumn).Value = $sValue^ ERROR About six thousand lines were produced in the file successfully, but I was wondering what could have caused this error?
here is a UDF that uses input controls to imitate a spreadsheet.
Here are the functions:
9/1/2011: Added Example 1