aleph01 Posted June 18, 2013 Posted June 18, 2013 (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 June 18, 2013 by aleph01 Meds. They're not just for breakfast anymore.
water Posted June 18, 2013 Posted June 18, 2013 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 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
aleph01 Posted June 18, 2013 Author Posted June 18, 2013 Thanks, Water, I'll have a look right now. Meds. They're not just for breakfast anymore.
water Posted June 18, 2013 Posted June 18, 2013 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 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
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