Milas

Exporting array to excel file

8 posts in this topic

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

Share this post


Link to post
Share on other sites



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?

1 person likes this

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 Gude
How 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

Share this post


Link to post
Share on other sites

#3 ·  Posted (edited)

thank you for your reply. I am wanting to send data from an array to a specific excel file

Edited by Milas

Share this post


Link to post
Share on other sites

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.

1 person likes this

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Thank you water

I 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.

Share this post


Link to post
Share on other sites

Example 2 should fit. It writes an 1D array to Excel. Example 3 uses an 2D array.

1 person likes this

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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 .csv

If you want to add data to an existing excel file or have a higher level of interaction I would use Waters Excel.UDF

1 person likes this

Share this post


Link to post
Share on other sites

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

Share this post


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