How to generate numbers in excel using autoit?

[ermilemerson]

Guys may i know how to generate numbers (1-infinity) in a column in ms excel using autoit?

e.g.

A

1

2

3

4

5

5

6

7

8

9

10

11

.

.

.

.

.

10000

Thanks

[Minikori]

Guys may i know how to generate numbers (1-infinity) in a column in ms excel using autoit?

e.g.

A

1

2

3

4

5

5

6

7

8

9

10

11

.

.

.

.

.

10000

Thanks

If this is what I'm thinking... Look in the help file at For...Next loops and do that with typing the variable then sending down and repeat.

[Malkey]

Try this. A modified example from help file.

; ***************************************************************
; Modified Example 1 - Write to a Cell after opening a workbook and returning its object identifier.  Then Save and Close file
; *****************************************************************
 
 #include <Excel.au3>
 
 Local $oExcel = _ExcelBookNew();Create new book, make it visible
 
 For $x = 1 To 100
     _ExcelWriteCell($oExcel, $x, $x, 1);Write to the Cell
 Next
;MsgBox(0, "Exiting", "Press OK to Save File and Exit")
;_ExcelBookSaveAs($oExcel, @TempDir & "\Temp.xls", "xls", 0, 1); Now we save it into the temp directory; overwrite existing file if necessary
;_ExcelBookClose($oExcel); And finally we close out
;