[Solved] For-Loop, counting in Letters

[Radiance]

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

[JLogan3o13]

@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")

 

[water]

The Excel UDF comes with a function to convert column letters to numbers and vice versa.
Please check _Excel_ColumnToLetter and _Excel_LetterToColumn.

[Radiance]

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!!
 

[water]