Jump to content

IS it even possible to create working spreadsheets within AutoIt GUI , help with directions and ideas inside

Recommended Posts

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


Link to comment
Share on other sites

  • Moderators


My GUIListViewEx UDF (look in my sig for the link) allows you to edit the content of ListViews - and much else of what you require. Why not download it and run the examples to see what it can do - and then perhaps make a feature request if you really need something more (no promises, mind).


Public_Domain.png.2d871819fcb9957cf44f4514551a2935.png Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind

Open spoiler to see my UDFs:


ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area


Link to comment
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

  • Create New...