Jump to content
Sign in to follow this  
ermilemerson

How to generate numbers in excel using autoit?

Recommended Posts

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

Share this post


Link to post
Share on other sites
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.

For those who are asking questions, look in the help file first. I'm tired of people asking stupid questions about how to do things when 10 seconds in the help file could solve their problem.[quote name='JRowe' date='24 January 2010 - 05:58 PM' timestamp='1264381100' post='766337'][quote name='beerman' date='24 January 2010 - 03:28 PM' timestamp='1264372082' post='766300']They already have a punishment system for abuse.[/quote]... and his his name is Valik.[/quote]www.minikori.com

Share this post


Link to post
Share on other sites
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
;

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  

×