at the beginning i need to make my script to read and write bunch numeric data into another program
and then i googling there and there and make my own script
my script read CSV
i used to copy my data into excel column A and then i save as CSV and then my ahk program read and send it into another program
here's my script
Code: Select all
Loop, read, C:\Users\Reza\Dropbox\Dispenda\Sulapan\Sulapan Jilid 3 Auto Reborn\%personel%\Status\%k%\%l%.csv
{
Loop, parse, A_LoopReadLine, CSV
{
Send, %A_LoopField%
Send, `n
sleep 1250
Loop, 2
{
Send, `n
sleep 150
}
if (l>=3)
{
Send, 7
}
if (l<=2)
{
Send, 0
}
Send, `n
sleep 200
Send, `n
sleep 1250
}
}
which is i need 3 column excel
i know i should move from csv into xls/xlsx and then read it
but i can't find how to read excel based on column
like put column A value excel into arrayA and then put column B value excel into arrayB and so on
i hope i don't make you guys get confused for my bad english
hope you guys can help me
thanks in advance