7 replies to this topic

[Surreall]

Hi all,

I have really managed to confuse myself.

I have two simple loops one reads values and inputs into an active window


With this code below i would like to input each line from the text file into either excel in column A, or into a csv file where i can also input values from another loop.

Loop, read, %A_ScriptDir%\itemstosearch.txt
{	
	
        ;"Say the first line in the text file is "Holy Moly" and the second one is "Jeremy Crackers""
        ;"Here i would like to put Holy Moly into cell 2 in column A in excel, and put jeremy crackers in cell 3 in Column A in the same ;spreadsheet"	

	Loop, Parse, A_LoopReadLine
		{
		x = %A_LoopField%
		if (x = "")
			{
			Send {Space}
			}
		Else
			{												
			Send {%x%}
			}
		}

}

The second loop returns "output" variable on each iteration which i would like to put into column b

I suppose i need to create an excel file in the script folder first, which i could name simply "results"

i read up about excel and csv files, but all i managed to was confuse myself

Any help would be greatly appreciated

Regards

Surreall

[FischGeek]

AHK Basic
Since CSV is exactly what it sounds like (comma separated values) just create your list first and append it all at once.

row1 := "a1,b1,c1"
row2 := "a2,b2,c2"

FileAppend, %row1%`r%row2%, %A_Desktop%\test.csv
Run, %A_Desktop%\test.csv

AHK_L
Since COM is built into _L, you can do something like this: <!-- m -->http://www.autohotke... ... 63#p401063<!-- m -->

[Surreall]

To get my script immediately above to work, do i have to download a new library for it?

Regards

Surreall

[Surreall]

I am getting somewhere now, one last question ...maybe

with this code

oExcel.Range("A1").Value := 3

Is it possible to make the A1 dynamic, ie have "A%B%" for example (this doesnt actually work), where B is a variable?

Regards

Surreall

[Surreall]

Solved

Instead of range("A1")

i used cells(1,1), as you can put a variable in replace of either 1

Regards

Surreall