Milas Posted December 3, 2015 Posted December 3, 2015 Hello,I am very new to Autoit so I have a hard time understanding the language used in UDF files. But I was wondering if someone could dumb down for me how to Export information into an array?im writing a gui that captures information into an array but I need that information stored into a local database. I found some threads that I think gives me the answer I just don't understand all that well what they are doing
BrewManNH Posted December 3, 2015 Posted December 3, 2015 I'm a little confused as to which way you want the data to move.Are you wanting to put the data in the array into Excel.Or are you wanting to use a database?Or, are you wanting to get the data into the array from some other program and then doing something with that data in the array? Milas 1 If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag GudeHow to ask questions the smart way! I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from. Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays. - ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script. - Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label. - _FileGetProperty - Retrieve the properties of a file - SciTE Toolbar - A toolbar demo for use with the SciTE editor - GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI. - Latin Square password generator
Milas Posted December 3, 2015 Author Posted December 3, 2015 (edited) thank you for your reply. I am wanting to send data from an array to a specific excel file Edited December 3, 2015 by Milas
water Posted December 3, 2015 Posted December 3, 2015 Welcome to AutoIt and the forum!Please have a look at the Excel UDF that comes with AutoIt. The example script for function _Excel_RangeWrite will show you how to do. Milas 1 My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Milas Posted December 3, 2015 Author Posted December 3, 2015 Thank you waterI was looking at that before but due to my lack of knowledge I was having a hard time understanding what was going on. is there maybe a dumb down samples I could look at somewhere? ive literally only been scripting on and off at work in my leisure time for about 2 months now.
water Posted December 3, 2015 Posted December 3, 2015 Example 2 should fit. It writes an 1D array to Excel. Example 3 uses an 2D array. Milas 1 My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
ViciousXUSMC Posted December 3, 2015 Posted December 3, 2015 If you just want to write an array to an excel file I have used this and it worked great.You can also do a file write loop and create a .csvIf you want to add data to an existing excel file or have a higher level of interaction I would use Waters Excel.UDF Milas 1
Milas Posted December 3, 2015 Author Posted December 3, 2015 Thank you guys after some painful research and help from you guys I was able to come up with this GUI. being really new at this I probably didn't do it in the most efficient way but it performs these functions saves files in a folder if it doesn't exist; every month creates a new file, and puts all data into a new cell.Thank You all again so much Check in Process.au3
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