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
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?