Radiance Posted May 10, 2016 Share Posted May 10, 2016 (edited) Hi all, I need to progress Microsoft Excel colums using a for-loop: For $i = Asc("A") To Asc("Z") ;Do thing in column Chr($i) Next Once I reach column Z I obviously have to stop. How would I go about this once the colums start to be so many that the order looks like "...X, Y, Z, AA, AB, AC, AD, ...." ? Edited May 11, 2016 by Radiance Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted May 10, 2016 Moderators Share Posted May 10, 2016 @Radiance do you know the columns you want to reference ahead of time, or will it be unknown? If you know, you can just use _Excel_RangeWrite: #include <Excel.au3> Local $oExcel = _Excel_Open() Local $oWorkbook = _Excel_BookOpen($oExcel, @ScriptDir & "\Test.xlsx") _Excel_RangeWrite($oWorkbook, Default, "Testing", "A1:AA1") "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum! Link to comment Share on other sites More sharing options...
water Posted May 10, 2016 Share Posted May 10, 2016 The Excel UDF comes with a function to convert column letters to numbers and vice versa. Please check _Excel_ColumnToLetter and _Excel_LetterToColumn. Radiance and pranaynanda 2 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 Link to comment Share on other sites More sharing options...
Radiance Posted May 11, 2016 Author Share Posted May 11, 2016 16 hours ago, water said: The Excel UDF comes with a function to convert column letters to numbers and vice versa. Please check _Excel_ColumnToLetter and _Excel_LetterToColumn. Exactly what I was looking for, tyvm!! Link to comment Share on other sites More sharing options...
water Posted May 11, 2016 Share Posted May 11, 2016 Synapsee 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 Link to comment Share on other sites More sharing options...
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