kor Posted March 26, 2011 Posted March 26, 2011 Basically what I'm looking for is the functionality to display an array (or array looking) and have a user be able to input directly into that array. Or copy paste lots of information into it. similar to an excel sheet or something but without the overhead of excel, or having to input the data into some other thing then read it into an array. Can this be done?
martin Posted March 26, 2011 Posted March 26, 2011 Basically what I'm looking for is the functionality to display an array (or array looking) and have a user be able to input directly into that array. Or copy paste lots of information into it. similar to an excel sheet or something but without the overhead of excel, or having to input the data into some other thing then read it into an array.Can this be done?How big might the array be? Eg how many columns and how many rows? Serial port communications UDF Includes functions for binary transmission and reception.printing UDF Useful for graphs, forms, labels, reports etc.Add User Call Tips to SciTE for functions in UDFs not included with AutoIt and for your own scripts.Functions with parameters in OnEvent mode and for Hot Keys One function replaces GuiSetOnEvent, GuiCtrlSetOnEvent and HotKeySet.UDF IsConnected2 for notification of status of connected state of many urls or IPs, without slowing the script.
Moderators Melba23 Posted March 26, 2011 Moderators Posted March 26, 2011 kor, malkey developed one of my scripts into something which seems to be exactly what you are looking for - take a look here. M23 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: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area
kor Posted March 26, 2011 Author Posted March 26, 2011 It seems to be too restrictive. It seems I'm going to have to first create a blank spreadsheet, pop up the spreadsheet, then when the user is done inputting all the information, somehow save it, read it, then bring it back into an array.
martin Posted March 26, 2011 Posted March 26, 2011 (edited) It seems to be too restrictive. It seems I'm going to have to first create a blank spreadsheet, pop up the spreadsheet, then when the user is done inputting all the information, somehow save it, read it, then bring it back into an array.Here is the demonstration of a string grid (spreadsheet) I posted in example scripts.You will need to comment out line 19 which is for a constant now included in one of the AutoIt include files. Note that you can resize the window to see more cells as well as scroll them into view horizontally and vertically. You can navigate with the earrow keys as well and you can enter things in the cells and you can resize column widths but it is slow to redraw the cells. I think I might have had problems with more than 500 rows which is why I asked how many rows.The problem is that it is not an easy example to understand. I used a simplified version in a project and If it looks like what you need then I might be able to create a simple UDF so you can create the spread sheet, specify the colums and rows and labels to use etc. I only used A,B,C for headings in the example but in the project where I used it in I had meaningful names.One advantage might be that it is flexible. For example you could easily modify it to specify something that is to happen whenever a cell is changed. But to add things like cells which contain calculations was never developed although I think it was allowed for to some extent. Edited March 26, 2011 by martin Serial port communications UDF Includes functions for binary transmission and reception.printing UDF Useful for graphs, forms, labels, reports etc.Add User Call Tips to SciTE for functions in UDFs not included with AutoIt and for your own scripts.Functions with parameters in OnEvent mode and for Hot Keys One function replaces GuiSetOnEvent, GuiCtrlSetOnEvent and HotKeySet.UDF IsConnected2 for notification of status of connected state of many urls or IPs, without slowing the script.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now