Sign in to follow this  
Followers 0
aleph01

inserting array data into Excel

4 posts in this topic

#1 ·  Posted (edited)

Good afternoon.  I am collecting certain GetFileVersion data in an array.  It then needs to be written to an Excel spreadsheet.  This process will happen for several iterations.  My mind is fried, and I can't get my head around how to tell AutoIt that "no, I don't want you to overwrite the cells from the last iteration, I want you to start on the next row, so that in the end, I'll have data from all iterations in the spreadsheet."  I don't have any code for this yet.  I can't figure out the logic for getting the new iteration to be placed on a new row.

Can anyone point me to some examples, give me the magical tip, or otherwise get my stalled brain going?

Thanks.

edit:  Peraps having the data coming in from the individual computers populate the array, and then only having to write to the Excel spreadsheet once is a better way?

Edited by aleph01

Meds.  They're not just for breakfast anymore. :'(

Share this post


Link to post
Share on other sites



Please have a look at my Excel Rewrite UDF. Function _Excel_RangeWrite should do what you want.


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

Thanks, Water, I'll have a look right now.


Meds.  They're not just for breakfast anymore. :'(

Share this post


Link to post
Share on other sites

Be aware that my UDF is still a Alpha version and needs AutoIt 3.3.9.x (at least for the _Excel_BookAttach function). But I hope to make it work with 3.3.8.1 quite soon.


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

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
Sign in to follow this  
Followers 0